Solving 100 Python Pandas Problems! (from easy to very difficult)

No video

Solving 100 Python Pandas Problems! (from easy to very difficult)

Рет қаралды 97,830

Keith Galli

Күн бұрын

Пікірлер: 107

@JatinKumar-cn9wt 4 ай бұрын

Are you crazy man , 5 hour + course only for pandas , man your dedication for teaching is amazing

@KeithGalli 4 ай бұрын

I appreciate the support!

@raphaelmatthew5165 4 ай бұрын

Please guys give this video a like if you haven't, it takes a lot of work to create such a masterpiece. Welcome back Keith🎉.

@KeithGalli 4 ай бұрын

Woo!!! 5 hours of Pandas practice, what could be better. Hope you all enjoy!

@jonpounds1922 4 ай бұрын

Will watch this on repeat until I am an expert. Thank you.

@KeithGalli 4 ай бұрын

@@jonpounds1922 haha my man 💪

@simonmasters3295 4 ай бұрын

It will not make you and expert Consider the examples trivial. Average age of each animal (a SQL "group by" for instance...) try doing it this way with a million animals and computing the variance at the same time

@PaYaMv2 4 ай бұрын

You are a sight for sore programming eyes Keith! We cannot thank you enough for this!!

@foland2619 4 ай бұрын

Awesome work and skills Keith. Thank you, great effort

@JW-pu1uk 4 ай бұрын

Dude I freaking LOVE your content. I am so stoked to see this video and have it bookmarked for the rest of my data science career lol

@KeithGalli 4 ай бұрын

haha love that! Glad you like the content :)

@ngoclinhvu5381 4 ай бұрын

5 hours of pandas puzzles??? Just what I need!

@ngoclinhvu5381 4 ай бұрын

never thought I'd ever say that in my life tbh

@KeithGalli 4 ай бұрын

@@ngoclinhvu5381 Haha very fair. I found these exercises very educational for me personally, so hope that you do as well!

@nabinkoirala5054 Ай бұрын

you are so genuine and humble!

@rrrprogram8667 Ай бұрын

Subscribed.... the way you are doing is a genuine way of making mistakes and then learning

@vedantlssj2 2 ай бұрын

This the kind of content that makes KZfaq the great source of learning it is!

@d.g0101 4 ай бұрын

This is what I was looking for. Thanks Keith

@klausditrich7323 4 ай бұрын

I'm too old for all the Minecraft or Fortnight streams, so here I'm and loving it :-)

@KeithGalli 4 ай бұрын

Hahaha love this

@JudyLuHe Ай бұрын

Hi Keith, Genuinely appreciate you solving all these pandas problems. I am not sure if you already have but I was wondering if you could also do one on the 100 Numpy problems? Again, thanks for you work.

@conykuo4308 3 ай бұрын

5 hours pandas video is crazyyyy. Must give a thumb up!

@AgustinGonzalez-tz3yr 4 ай бұрын

19:30 I do this a lot, by passing a dict to the agg function after grouping (it allows you to asign multiple operators to several cols at once). Eg df.groupby(“animal”).agg({“age”:”mean”})

@KeithGalli 4 ай бұрын

This is super useful, thank you for the tip!

@thiagosiqueira4690 2 ай бұрын

this works too, df.groupby('animal').mean('age')

@AgustinGonzalez-tz3yr 2 ай бұрын

@@thiagosiqueira4690 I think that doesn't work for grouping by multiple columns and adding a specific function for every column

@ryandavis280 3 ай бұрын

OMG keith you are a lifesaver! thank you!

@renatolippi 3 ай бұрын

Excellent! Thank you very much for this video!! Please more with this format 👏

@abdulbasitnisar 3 ай бұрын

Thank you such much!! whatever you are doing actually is life changing for people like me who is self learning these! Thank you!!!

@balajijadhav6080 Ай бұрын

Thank you so much sir for this pandas session

@Kidpambi 4 ай бұрын

It is great to have you back teaching 🎉

@tdcode 3 ай бұрын

Man, you're crazy 🤣🤣🤣🤣🤣🤣🤣🤣🤣. This is awesome! Thanks for a colossal and great video!!!🎉🎉

@paraglide01 2 ай бұрын

Thanks man, I was just looking for getting into Pandas.

@soroushnazari5596 4 ай бұрын

Great to have you back Keith! Going to watch it over the next couple of days and it’s gonna be my sort of bible I guess for future reference haha

@KeithGalli 4 ай бұрын

Love that! I found the exercises very educational myself.

@rrrprogram8667 Ай бұрын

Blindly subscribed

@chetan8577 4 ай бұрын

This video would be really helpful. Keep up the great work!😊

@loganmclaughlin1288 4 ай бұрын

Love the long form !

@user-ed3bs1vq8b 4 ай бұрын

answer to question 23 is incorrect: it say the ROW mean, while df.mean() gives you the column mean

@Soso65929 4 ай бұрын

more of this buddy enjoyed each second

@chandrasekars8904 4 ай бұрын

This is really an excellent channel on Python like "techie talkee"

@ameyb9241 Ай бұрын

Thanks Keith! This is so goodd

@chandanirohan 3 күн бұрын

in your solution no 24, the operation df - df.mean(axis=1) won't work directly because the dimensions won't align

@APP-ld6jf 4 ай бұрын

Looking forward to numpy puzzles now!!

@vishalcrazy5121 3 ай бұрын

Thank you for this Keith .

@second1799 2 ай бұрын

This is awesome! can you do for other libraries too please!!!

@souravbarua3991 3 ай бұрын

Thank you for making such wonder videos on python.🙏.please make some videos on pyspark also.

@rodrigo100kk Ай бұрын

At 33:57 - "22) Filter duplicate integers" - Might as well try: pd.DataFrame(data=df['A'].unique(),columns=['A'])

@sarveshpadav2881 3 ай бұрын

24:27 We can use gropyby to count the animals in the following way... df.groupby('animal')['animal'].count()

@AndyJagroom-ur7xh Ай бұрын

Can you do the numpy one also

@rohitsharma-mg7hd 4 ай бұрын

another solution to puzzle 26: for i in [0,1,2,3,4]: a=df.iloc[i].sort_values(ascending=True).index[7] print (a)

@NuanceWebsites 3 ай бұрын

Bro, you are a genius!!!

@Ghost____Rider 20 күн бұрын

Great video! However I believe your solution for q23 was wrong. You subtracted the mean of the entire DataFrame instead of the mean of each row. It worked for your example of np.ones because the entire DataFrame had the same mean as the mean of each row (a mean of 1). You want a solution that subtracts a different value for each row, namely the row's mean.

@priyatiwari234 Ай бұрын

great work

@AchuVlogs 4 ай бұрын

Awesome!! Can you please make one for Pyspark? :)

@StalkedHuman 4 ай бұрын

What do you think is a good method to concatanate a string value from datafram column to anothee dataframe column by index key. Example, df_1 rows 10, 20, 26, 30, 40 column 5 (string) concatonate to df_2 rows 9, 19, 25, 29, 39 column 1?..

@rrrprogram8667 Ай бұрын

I believe the answer for the 23rd problem is not the correct one because the average mean of the vertical column is also one

@yaj_at8787 2 ай бұрын

thanks for this...needed

@jehfodelrey 4 ай бұрын

Thanks for this. Do you know some app or website, to practice or improve my scripting skills?

@Aya_Chagra 4 ай бұрын

Very Nice ⚡thanks a lot ⚘

@ricklove8358 Ай бұрын

i think i have a better solution for filtering rows which contain the same integer as the row above df = pd.DataFrame({'A': [1, 2, 2, 3, 4, 5, 5, 5, 6, 7, 7]}) def precedingDuplicateCheck(row): if row.name == 0: prev = None return False else: prev = df.loc[row.name -1,'A'] if prev == row['A']: return True else: return False df_new = df[~df.apply(precedingDuplicateCheck,axis=1)] df_new

@gamersgame43 Ай бұрын

1:23:56 Here's the updated code of pandas for the question 27. df.groupby(['grps'])['vals'].nlargest(3).groupby(level=0).sum()

@nacef7606 4 ай бұрын

for the 22th quiz it could be done as simple as for i,k in df.items(): df=set(k)

@KeithGalli 4 ай бұрын

A couple of issues with the set solution. One is that a set is not guaranteed to preserve any order that numbers are inserted into it, so even though it worked in this example, if we changed the numbers to [3,3,2,2,1,1,8,8,9], the output show {1,2,3,8,9} instead of [3,2,1,8,9]. Another issue with the set solution is that if a number reappears later on in the list, it will disregard it from the solution. So if we had [1, 2, 2, 3, 4, 5, 5, 5, 6, 7, 7, 2, 2] as our input, your solution would output {1,2,3,4,5,6,7} while the correct solution would be [1,2,3,4,5,6,7,2]. Hope this is helpful!

@aloSolo 4 ай бұрын

You look great 🎉 and thanks for posting this video.

@KeithGalli 4 ай бұрын

Thank you! 😊

@Cynosure11 4 ай бұрын

Thank you for your video, Keith! Question for you, do you think its too late to get data science job in 2024?

@KeithGalli 4 ай бұрын

The job market is challenging right now, but data science positions aren't going anywhere. You definitely can still get a data science job in 2024. That being said, I wouldn't only look for data science positions. There are a lot of software engineering & data engineering roles that use a similar skillset that can be less competitive to land. I'd recommend keeping track of the most popular skills on job openings for all these types of roles, and tailor what you learn moving forward based on that. I also recommend trying to network with people that are working at companies you find interesting. You'll give yourself a much better chance at landing a data science job if you are referred by someone already at a company you are applying to. Job postings on a site like LinkedIn can really difficult to progress in the process because so many people apply.

@derekborders9647 2 ай бұрын

Weird to see you open VSCode with the ui when the cli command is the easiest one to add to your other flow once you’re in that directory after cloning. code . Opens the current directory in VSCode.

@jdmcivicrrr 4 ай бұрын

This is awesome. Thanks. ❤

@KeithGalli 4 ай бұрын

You are very welcome!

@chalijutt3478 2 ай бұрын

could somebody explain q23 because the way he is doing, i think its wrong because "df.mean()" going to give us the mean values with respect to individual columns not rows and then also in subtraction each mean value going to subtracted from individual columns respectively. we have to use the "df.mean(axis=1)" and then in subtraction also we have to take care of it . I have done it like that "df.subtract(df.mean(axis=1),axis="index").multiply(-1)". Please correct me if i am wrong.

@Ghost____Rider 20 күн бұрын

His solution is wrong, I agree, but not for the reason you say. His solution calculated the mean of the entire DataFrame but he should've subtracted the mean for each row (axis=0). Edit: Never mind, I agree with you.

@chamaraweerasinghe5836 4 ай бұрын

Thanks Lot Keith...😘

@sauravgoyal19 3 ай бұрын

Could you share the VS Code extension you use that provides function descriptions as you type?

@sofiarequena2616 4 ай бұрын

Great video!!

@dsisimridijsbs1969 2 ай бұрын

Hi guys, is there something similar or equivalent for SQL and scikit-learn? Thank you in advance!

@panth5501 3 ай бұрын

Great content, solution of 23 I believe is wrong.

@Ghost____Rider 20 күн бұрын

I agree, he subtracted the mean of the entire DataFrame instead of each row. It worked for his example of np.ones because the entire DataFrame had the same mean as the mean of each row (1).

@FIBONACCIVEGA 4 ай бұрын

Such a good videos!!!

@sarvanandgaikwad3048 4 ай бұрын

Do the same for all the popular libraries.

@MrBeavis2014 4 ай бұрын

thank you very much

@dianapestriaeva9853 4 ай бұрын

pure gold 🤩

@starlordhero1607 3 ай бұрын

Bro, can you do it for other libraries like numpy, seaborn, and matplotlib. Please !!!!!

@sssimp4216 4 ай бұрын

Thank you 😭🩵🩵

@brigitayantie 4 ай бұрын

You really so serious learn and post this class

@ikersanchez8222 4 ай бұрын

I love your content

@DataScience-oj4hc 2 ай бұрын

1:10:03

@saikumar7247 3 ай бұрын

sir could u make same like numpy video

@realzeejay 4 ай бұрын

great video! however, regarding the usage of the terminal to create directories etc at 0:59 , can anyone recommend some youtube videos or sources to get more familiar with it? thanks a bunch! good luck getting good at pandas everybody :)