Learn Pandas in 20 minutes!

[@hansrc4469]

7:21 ~ Negation 9:10 column name change 10:31 reset index 12:30 lowercase letter 15:14 concatenate dataframes 15:36 merge dataframes

[@misraturp]

Thank you!

[@redahegazy8605]

hello, I am new to python and pandas, just finished my elementary course, and it got me mad. But actually, with you, this video is straightforward, simple, easy, and fun. thanks a lot

[@misraturp]

Glad I could help!

[@ShashankData]

Great overview of Pandas Misra! All the important functions in 20 mins.

[@misraturp]

Thank you! I'm glad you liked it. :)

[@ahmedlateef2985]

I am a #450 liker. I really appreciate what you are doing. Many thanks dear. You are helping a master degree data analyst from Iraq :)

[@misraturp]

That's great to hear, thank you Ahmed!

[@faisalIqbal_AI]

00:02 Pandas is fun and useful, learning the fundamentals and common functions. 01:58 Learn how to write data from a Pandas data frame to a CSV file. 04:04 Pandas can return Series or DataFrame objects based on the data requested. 06:07 Understanding and applying conditions in Pandas dataframes 08:09 Adding new columns and renaming columns in Pandas 10:20 Resetting index and sorting values in Pandas 12:22 Convert names to lowercase and assign to dataframe 14:13 Concatenate data frames using Pandas. 16:12 Merge and aggregation in Pandas 18:14 Pandas provides value counts and group by functions for data exploration and cleaning. 20:09 Pandas makes plotting simple but may require customization for better visuals 22:07 Histograms are useful for detecting outliers and data issues.

[@KL-es9bt]

You're amazing. I have an interview on data manipulation. Your tutorial is on point. Thank you Misra.

[@misraturp]

Awesome to hear!

[@techgalaxy100]

Excellent video!! Subscribed already..Please make a video on how to use regex in pandas and how to split complex data. Splitting Fullnames to First, middle and last and First and Last name. Thanks

[@CaribouDataScience]

How can I use the code to create a new column? df['new_column']= df[(df['age']>30) & (df['fare']

[@nazihf478]

Very Nice and Simple Explanation. Could be used as a quick reference for beginners. 👍👍👍👍

[@alihanucar]

sabaha kadar anlat dinleyelim Mısra Reyissss

[@antoniojperezcastro5013]

some functions are not working in my code. the .sort_values(by='whatever i put there) is not working. any advice??

[@Tiger_RCD]

Truly amazing tutorials ! You are so great, clear and listenable. Thanks for all your work 🙏 Keep on going 🌞

[@misraturp]

Thank you Jonathan! :)

[@alokjha780]

Thanks...very crisp and clear!!!!

[@syedkhundmir8938]

Superb ur explanation is awesome!! I will surely buy ur course.

[@misraturp]

Thank you Syed! I'm happy to hear it was useful. And can't wait to welcome you to the course. :)

[@akalewoldwoldie3321]

you are a blessing from above ? Great video !!!!

[@saulmartinez7351]

Hey, nice video. Can you make a real case data analysis and show us how the analysis impact in a decision take? 🙏

[@hendrag593]

Thanks Misra, this is really great video to learn Pandas

[@misraturp]

You're very welcome :)

[@CsForEveryOne]

Thank you Misra great content it helps me a lot in my FYP

[@misraturp]

Great to hear!

[@onkarpatil140]

What do you do for a living? Are you a full time teacher?

[@mbilalgoker]

great explanation. calm and relaxing. you have a new sub!

[@misraturp]

Welcome!

[@mychallee3397]

Amazing videos! Keep up the great work!

[@misraturp]

Thanks!

[@chiragsheth4936]

Nicely explain mam... Thanks!!!

[@vijhey3850]

thanks! also make video on confidence interval in pandas.

[@misraturp]

Thank you!

[@misraturp]

All you need to know about Pandas in one place! Download my Pandas Cheat Sheet (free) - misraturp.gumroad.com/l/pandascs

[@pavanasopa250]

I have given my mail info, but, did not receive any cheat sheet.

[@misraturp]

Hey ​@@pavanasopa250, have you checked your spam folder? Because I see that the mail went out to you in my system.

[@semakaran611]

Thank you very much Misra for the great content!

[@misraturp]

My pleasure!

[@lfmtube]

Thanks! Most usefull for me. New subscriber and awaiting for more. The best!

[@misraturp]

You're welcome and thank you!

[@srid1868]

very helpful, Thanks :)

[@brunokexx]

perfect! thanks a lot.

[@sheidalv]

Awesome job!

[@sonsam3170]

you look exactly like my prof it is like watching her on youtube hhhhhh thank you so much for the information.

[@misraturp]

Haha that's a funny coincidence! You are welcome!

[@TheSoonAnn]

very clear explaination

[@misraturp]

Thank you!

[@kennethstephani692]

Great video!!!

[@misraturp]

Thanks!

[@colinhuang2325]

Thanks a lot this is so nice!

[@misraturp]

You're very welcome!

[@leonmaru9058]

awesome stuff

[@clear1948]

Never stop smiling. You are so sweet 💗

[@misraturp]

Thank you

[@Avi-lw4mn]

Misra, where can I connect with you Ma'am?

[@misraturp]

Hi Avi, if you have any questions, I can answer them here. :)

[@Avi-lw4mn]

Misra please make series or maybe single video covering sql required for data analyst and scientist role so that we know we can land a job surely.It will be greatly helpful for aspiring data science students.If possible Nosql

[@misraturp]

Hey Avi, thanks for the suggestions. I've noted them down for future video ideas. :)

[@krispyren]

thanks for the video. Was very helpful :)

[@misraturp]

You're very welcome :)

[@massoudkadivar8758]

Awesome 👌👌👌

[@misraturp]

Thanks 🤗

[@michelleganggay5098]

Great! thank you Misra

[@misraturp]

You are very welcome :)

[@sophisticatedanimation]

cool intro!

[@misraturp]

Thanks!

[@asfah301]

I don't get it why did you use +1 in here [ "Parents/children Abroard"] +1]

[@misraturp]

+1 is the person who the row is about. Parents/children Aboard is that person's parents and children. So to get the total number of people a row represents we have to add 1 to that number.

[@MachineLearningPro]

Great content! If you want take a look at my Pandas tutorial as well.

[@macbcheesy]

Great video :)

[@misraturp]

Thanks!

[@kaghak1422]

Thank You...Thank You.... Thank You... Thank Youuuuuuuuuuuuuuuu

[@misraturp]

You are most welcome :))

[@grivineochieng6018]

Thank you so much Misra, very much helpful. How do you create a data frame with label columns after using the value_counts method? For instance, after applying the value_counts method to a column, how do you recreate it into a data frame with two columns(one with records of the original column and the other with the count values eg "names" and "count" columns)

[@misraturp]

You are very welcome Grivine. :) To create a dataframe out of the value_counts() results, just wrap them into a dataframe creator. It'd look like this: import pandas as pd pd.DataFrame(my_df["random_column"].value_counts()) But you'd have to update the column names because as you'll see they'll not be accurate.

[@grivineochieng6018]

@@misraturp I have implemented as follows: df=pd.DataFrame(innovation_data["Preferred_Chnl_Sch"].value_counts()) df.columns = ['pref', 'count'] df.head() I get an error, " ValueError: Length mismatch: Expected axis has 1 elements, new values have 2 elements " I think it is because the dataframe created only has a single column and not two so renaming with the .columns method doesn't recognize one parameter. How do you create two columns from a single column with the value_counts method?

[@misraturp]

Ah, I think I know why. You should add .reset_index() at the end of your first line. Because the resulting dataframe of the first line has 1 index and 1 column. When you use reset_index, it sets the index as a new column and creates a new index, thus you will have 1 index and 2 columns. This will make it possible for you to rename the columns.

[@TeachBossExcel]

Very useful

[@misraturp]

Thanks!

[@samahmedalone6573]

Thanks, 👍👍👍

[@misraturp]

You're welcome! :)

[@0730pleomax]

Like it!

[@misraturp]

Thank you! Cheers!

[@yunisahmed4772]

amazing channel & a beautiful girl !

[@magicmedia7950]

Who else thinks she moves so fast?😂