Kindly develop a comprehensive video on data analysis using pandas, numpy and matplotlib. This should cover all aspects of data analysis. It starts from reading data from all sources, and then data wrangling, all manipulations, data extraction, REGEX, and all stuff which was done in Excel, and then writing it onto the Excel once the analysis is finished in python. Pls consider this. Thanks
It was a though short but quite comprehensive video on Data Frame and Series. Thanks a lot for sharing extensive information. However I have doubt that every-time I try to append query, it gave me this error " 'Data Frame' object has no attribute 'append'. I am naive to this topic. If possible could you please clarify. THANK YOU SO MUCHHHHHHHHH FOR this video
Hi Abhishek Sir very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
df = pd.pivot_table(data=df, index=['No_employee', "employee"], columns=['year','periods','Status'], values='salary', margins=False, dropna= True, aggfunc=(sum,count), margins_name='Grand Total') Hello, I would like to know how I can make a dataframe with data from an Excel file that adds all the values from column B to column Z, in the same way that counts all the values that exist in the columns. It also has to go through all the cells. please help.
Series is nothing simply a column of one dimensional, which can hold any kind of data where as index refers to as row of a dataframe or series. Now for list and dict these are two data structures of Python programming.
0:00 - Intro. What is Series, What is Dataframe - in simple terms. 1:20 - How to create Series in Jupiter notebook - high level. 5:17 - How to create Dataframe from dict - high level. 9:26 - Create an empty Dataframe. 10:46 - add rows to Dataframe 12:15 - another... ... and more ...
finally I come came across here and understood the topic..clear and crisp thankyou so much
Glad to hear :)
Awesome 👍🏻 keep it up🙏 sir
I follow your video on regular basis
Thanks a lot for giving valuable video 👍🏻
Thanks.
excellent explanation about pandas series and dataframe.Thanks for sharing with us 🙏 sir 👍🏻 👍🏻 👍🏻
You are most welcome.
Thanks mate. You're tutorial is really great and ready to understand.
I am glad it helps
Good work sir
High clarity and good Presentation. Important topics explauned. Very useful. Regards
my Boss, your video quality is up there
i tried all the examples, u gave, understood clearly
Excellent, the best tutorials on this subject. thank you..
Superb bro...!!!. 👌👌👌👌👌👌🙏🙏🙏🙏
Thank you brother. It was very useful.
Kindly develop a comprehensive video on data analysis using pandas, numpy and matplotlib. This should cover all aspects of data analysis. It starts from reading data from all sources, and then data wrangling, all manipulations, data extraction, REGEX, and all stuff which was done in Excel, and then writing it onto the Excel once the analysis is finished in python. Pls consider this. Thanks
It was a though short but quite comprehensive video on Data Frame and Series. Thanks a lot for sharing extensive information. However I have doubt that every-time I try to append query, it gave me this error " 'Data Frame' object has no attribute 'append'. I am naive to this topic. If possible could you please clarify. THANK YOU SO MUCHHHHHHHHH FOR this video
Way of explaining is really Amazing..
Hi Abhishek Sir
very useful video and very practical need everyone for every project ......very big thanks to share with us.
If it can possible can you plzz provide us excel data file which you used.
Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
Hi Ashish, Thanks for comment, In this video we haven't used any excel file and Yes we are providing the source data if it is used in lecture.
df = pd.pivot_table(data=df,
index=['No_employee',
"employee"],
columns=['year','periods','Status'],
values='salary',
margins=False,
dropna= True,
aggfunc=(sum,count),
margins_name='Grand Total')
Hello, I would like to know how I can make a dataframe with data from an Excel file that adds all the values from column B to column Z, in the same way that counts all the values that exist in the columns. It also has to go through all the cells. please help.
Thank you!
Thanks. It was helpful
I am glad its work for you.
Sir may I know where you are processing this data
Please upload next video 👍🏻
Will upload soon
Yes, plz upload more videos asap if possible, really awesome content sir
what is the difference between series, dictionary, index, and list please? how to distinguse them from each others. if you have examples
Series is nothing simply a column of one dimensional, which can hold any kind of data where as index refers to as row of a dataframe or series.
Now for list and dict these are two data structures of Python programming.
distinguish*
Great video! Take a look at my Pandas tutorial if you want.
0:00 - Intro. What is Series, What is Dataframe - in simple terms.
1:20 - How to create Series in Jupiter notebook - high level.
5:17 - How to create Dataframe from dict - high level.
9:26 - Create an empty Dataframe.
10:46 - add rows to Dataframe
12:15 - another...
... and more ...
don't shout or repeat so moany times gu's gu's ok, it is akward
Thanks for your feedback.
We need to be respectful and polite to the people who help us in our journey 😢