Python Pandas Tutorial : Series and DataFrame Basics #2
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- In this tutorial you will learn about Python Pandas Series and DataFrame Automation from basics to advance.
Pandas is a Python library used for data manipulation and analysis. It provides two primary data structures to work with - Series and DataFrame.
A Pandas Series is a one-dimensional labeled array that can hold data of any type (integer, float, string, etc.). The labels, called the index, can be integers or strings and provide a way to identify the data. A Series can be created from a list, tuple, dictionary, or even another Series.
A Pandas DataFrame is a two-dimensional labeled data structure with columns of potentially different data types. It is similar to a spreadsheet or SQL table. A DataFrame can be created from a dictionary of Series or a list of dictionaries. For example:
This video tutorial will cover a complete understanding of the following topics:
1.) What are Pandas Series and their indexes?
2.) Creating Pandas Series from different data structures
3.) Creating Pandas DataFrame from Lists, Dictionaries, etc.
4.) How to modify and create indexes of Series and DataFrame?
5.) Creating an empty DataFrame and appending rows and columns
6.) Creating DataFrame from scalar values
7.) Different ways to create Pandas DataFrame and Series.
In a DataFrame, each column is a Series, and the rows are identified by the index. The index can be specified when creating the DataFrame, or Pandas will use a default integer index if none is provided.
Pandas provides a wide range of functions and methods to manipulate and analyze data in Series and DataFrames, including indexing, selecting, filtering, grouping, merging, and more.
Pandas Data Science Playlist: • Python Pandas - Data...
Last Video:
Python Pandas and Data Automation Tutorial | What is Pandas | Features of Pandas.
• Python Pandas Tutorial...
Python Teaser: • A Beautiful Python Pro...
Python Playlist: • Python Tutorial for Be...
Python Data Structure Playlist: • Python Data Structure
Python OOPs Playlist: • Object Oriented Progra...
Python Excel Automation: • Excel Automation Using...
Python Project: • Python Project | Pytho...
finally I come came across here and understood the topic..clear and crisp thankyou so much
Glad to hear :)
excellent explanation about pandas series and dataframe.Thanks for sharing with us 🙏 sir 👍🏻 👍🏻 👍🏻
You are most welcome.
Awesome 👍🏻 keep it up🙏 sir
I follow your video on regular basis
Thanks a lot for giving valuable video 👍🏻
Thanks.
Good work sir
Thanks mate. You're tutorial is really great and ready to understand.
I am glad it helps
i tried all the examples, u gave, understood clearly
High clarity and good Presentation. Important topics explauned. Very useful. Regards
Excellent, the best tutorials on this subject. thank you..
Thank you brother. It was very useful.
my Boss, your video quality is up there
Superb bro...!!!. 👌👌👌👌👌👌🙏🙏🙏🙏
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..
Thank you!
Thanks. It was helpful
I am glad its work for you.
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.
Please upload next video 👍🏻
Will upload soon
Yes, plz upload more videos asap if possible, really awesome content sir
Sir may I know where you are processing this data
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.
Great video! Take a look at my Pandas tutorial if you want.
distinguish*
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 😢