Python Pandas Tutorial : Series and DataFrame Basics #2

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.

Last Video:
Python Pandas and Data Automation Tutorial | What is Pandas | Features of Pandas.

[nainagupta]

finally I come came across here and understood the topic..clear and crisp thankyou so much

[vimalchawla]

Excellent, the best tutorials on this subject. thank you..

[pc-knkt]

i tried all the examples, u gave, understood clearly

[vasutke]

High clarity and good Presentation. Important topics explauned. Very useful. Regards

[delmaregals]

Thanks mate. You're tutorial is really great and ready to understand.

[marvhan]

my Boss, your video quality is up there

[dss]

excellent explanation about pandas series and dataframe.Thanks for sharing with us 🙏 sir 👍🏻 👍🏻 👍🏻

[Avdheshkumar-kdqz]

Awesome 👍🏻 keep it up🙏 sir
I follow your video on regular basis
Thanks a lot for giving valuable video 👍🏻

[Al-Ahdal]

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

[tqwc]

Thank you brother. It was very useful.

[bhoomikadever]

Sir may I know where you are processing this data

[navikaur]

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 FOR this video

[rafaelsantana]

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.

[naifaalqahtani]

what is the difference between series, dictionary, index, and list please? how to distinguse them from each others. if you have examples

[ashishmohan]

Hi Abhishek Sir
very useful video and very practical need everyone for every project 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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[MachineLearningPro]

Great video! Take a look at my Pandas tutorial if you want.

[AndriiHaidai]

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 ...

[munivoltarc]

don't shout or repeat so moany times gu's gu's ok, it is akward