Check out our premium machine learning course with 2 Industry projects: codebasics.io/courses/machine-learning-for-data-science-beginners-to-advanced

Sir, You are amazing! I am really happy today I am able to perform these tasks today in pandas. I am really happy for that. Kudos Sir, what ever you are doing is really service to this human society. This is really super altruistic nature.

Great, great tutorial! You explain everything so wonderfully and clearly. Thank you!

@armagaan007

5 жыл бұрын

True

omg these vids are perfect for what I'm doing at my work. Exactly the kind of pandas info I was looking for. Thank you.

@timothypulliam2177

3 жыл бұрын

Thank you for Gravity Sir Isaac Newton

@RockStar-pw5wd

3 жыл бұрын

@@timothypulliam2177 😂😂😂

You are awesome man. You explain everything so clearly. Thank you so much

Best tutorials, clear and concise! Well done! Thank you so much!

@codebasics

3 жыл бұрын

👍☺️

This is an awesome video--totally on spot for what I am learning in coding bootcamp

@codebasics

4 жыл бұрын

Judy, I appreciate you leaving a comment of appreciation

you r awesome man keep going your learning style is very interactive , come with new lessons

@hpourmamih

4 жыл бұрын

He is AMAZING!!!!

Great video -- very clear and concise, thanks!

Just loved it. Thank you.

Awesome tutorial in very easy way.

great explanation, thank you so much. stay safe

thank you, it's easy and useful!

Thanks for the lesson! Really helpful!

It was a very good explanation. Thank you so much!

Excellent video! Thank you!

Thank you. This helped a lot.

@codebasics

5 жыл бұрын

Glad you found it useful Bianca. 😀

Great video, thanks for sharing!

great video. your examples are very helpful

Sir, your tutorials are very useful :) They are easy to understand, thanks for your help Sir.

@codebasics

4 жыл бұрын

👍👍👍

you are an angel:) thank you so much

Again very good lesson ,thank you

Very Sorted Educative video. within this short time I learned Pivot which I was not able to get From last week. Thanks a lot. Require Video on Pivot using If-Else in Python and CrossTab.

Thanks for great quality class!

@codebasics

3 жыл бұрын

You're very welcome!

you are awesome man you helped me learn a new thing today

Your tutorials are great.It will be great if you can give some assignment at the end of every tutorial. And also some small projects where we can apply our learning. Thank you code basics.

this really helped me thank you very much :)

@codebasics

3 жыл бұрын

I am happy this was helpful to you.

It's very helpful thank you

Very Informative Session.

you r awesome man keep going your learning style is very interactive , come with new lessons and advance pandas

@codebasics

4 жыл бұрын

👍👍🙏😊

Great teacher! Tks

Thankyou so much , for yr work I love it 💝

awesome tut.

You gain a subscriber and a like :) Thanks for sharing this!

Helpful, thank you

Good explanation....

Great tutorials ..please upload more videos on Python along with it's applications

@codebasics

5 жыл бұрын

sure. I just started a deep learning tutorial series with python today with first introduction tutorial. check it out on my channel.

Thank you sir! very helpful !

@codebasics

3 жыл бұрын

Glad it helped

you make things look easier........

awesome examples

Thank you so much sir

love u sir ji you made our day

Thank you sir.

You are No1.Super Duper

Great sir awesome

Very useful.

liked for your voiceover

God bless you and ur family

Thank you sir

hey. If I want to perform a roll-up function on my dataframe, how should i go about it

Hey, Nice tutorial. Why don;t you use the command : shift+tab, for the documentation by clicking and pressing that command on that specific function?

Good Video

@codebasics, At time 2:49 in some rows it is showing "none" and in some it is "NAN". Kindly explain.

superb video, I love this video.....👌👌👌☺☺☺🙏🙏😍🥰

@codebasics

3 жыл бұрын

Glad it was helpful!

very nice

Thanks for sharing this, can you tell me if there is any limit for number of lines or size of data to be processed.

Helpful!

@codebasics

4 жыл бұрын

Glad you liked it Dennis

Thanks for your Video ! Can you please let me know if we can put those collapse and expand functionality in actually generated pivot table in excel using python ??

so good

How do I write in to existing csv/excel file by adding new column? i.e., If I have a data in one column (column A) and want to add one column with conditional formula which will show "Yes/No" against all the values of Column A in new Column B, how can we do it? e.g. I have one column A containing the Talk time (in secs) of people. In new column B, I want to put "Yes/No" based on the condition that if Talk time is less than 30 sec its "Yes" else "No". How can I do that?

Can you please tell me how to use the mode function in the aggfunc. I have a categorical data set , i tried this ''''''outlet_size_mode = train.pivot_table(values='Outlet_Size', columns='Outlet_Type',aggfunc=(lambda x:mode(x).mode[0]) )'''''' , below error is coming , error : '

thank you man

@codebasics

3 жыл бұрын

You're welcome!

I have a question: why can't we use city as index for the first dataframe?

Need help . In excel , the fields which we fill in rows , columns , values . What is the code corresponding to that in pandas

hi, there is no aggfunc parameter in the current version of pandas?

thanks sir

That’s great! But what if I want to add a calculated field or calculated item to my pivot?

How can I get output in as decimal rather it giving as floating numbers?

Thank you

@codebasics

2 жыл бұрын

You're welcome

How would it work if I have a df with two columns, id and value. I have two values per id and I want to pivot to end up with a new dataframe that is id, value1, value2?

i thank you sir

@codebasics How to remove those unnecessary headers from pivot?

Hello , very nice video , so how to replace NaN values to my new york column at 2:24 dealing with the SettingCopyWarning ?

Can you do the reverse? columns to rows?

great

Hello bro, thanks all for your good work. Could you please tell me hot to export the entire pivot data into excel workbook including Indexing?

how to dowload the csv file from github i can't find out from the description please help anyone

at 0:33 you say x axis dates and y is city!! shouldnt it be the opposite? please explain

Step by step guide on how to learn data science for free: kzread.info/dash/bejne/iKKTz8-IpbTRg6Q.html Machine learning tutorials with exercises: kzread.info/dash/bejne/maGq2MOoktCdlbQ.html

can calculate the average of humidity,temperature with respective to the city using groupby function. just like at 4:16

pivot command gave an error: Index contains duplicate entries. Can not reshape."

Can we add multiple columns there ?

Thank you so much for sharing his video sir. Everyone understood easily sir. If you please share weather datasets through mail sir.

how to sort the cross tabs rows and column alphabetically?

Help me how to save pivot templet from python to csv

index contains duplicate entries,cannot reshape........How to fix this problem?

Hello Sir, I'm following the all videos in sequence, all are amazing. can you please help me to find out the practice files? In your blog I'm unable to find. this will be much helpfull

How can i download the CSV file?

Hi sir, How to save this pivot table in csv

sirf you creates the best content available but i know python learning data science to get a job also giving time to java programming will it be able to get a job without a degree

not ax or not, do/can do any nmw

df5 = pd.read_csv("weather3.csv") df5 df['date'] = pd.to_datetime(df['date']) display(df[['date']],df5) df6 = df5.pivot_table(index=pd.Grouper(freq='M',key='date'),columns='city') I am getting TypeError: Only valid with DatetimeIndex, TimedeltaIndex or PeriodIndex, but got an instance of 'Index'

How can I install pandas in python 3.8 Please guide

Can you pls suggest, what is the use case of pivot in pandas, when u can use excel or tableau? If the dataset is huge, anyways we won't be able to see the entire ouput in Jupyter Notebook?

@codebasics

5 жыл бұрын

pandas can handle much more larger datasets then excel. Excel has limit on how many rows it can handle whereas pandas can handle millions of rows seamlessly. In terms of visualization also jupyters next gen version jupyter lab has come out which can handle rendering of many many rows very efficiently. I will add a tutorial on that in future.

Hi Sir, im interested to learn python and related modules for data science or data analyst

I have a data in excel with 20 columns. I need to show the required data with 5 columns in Graphical or pie chart format. Can you help in getting that done??

@harishanmugam89

5 жыл бұрын

@@codebasics thank you will check and get back

In this video, you said x axis is city at 0.41 but it actually looks like Y axis..and date as X axis.. correct me if I am wrong

pivot_table : pandas.core.base.DataError: No numeric types to aggregate

How to download csv file

Not able to access the code file on github. Fix it and reply.