Python Pandas Tutorial 3: Different Ways Of Creating DataFrame

This tutorial covers 5 different ways of creating pandas dataframe. Pandas is a popular python library especially used in data science and data analytics.

Topics that are covered in this Python Pandas Video:
0:00 Introduction
0:41 How to create dataframe?
1:11 Create dataframe using read_csv() method
1:58 Create dataframe using read_excel() method
2:55 Create dataframe using python dictionary DataFrame() method
4:00 Create dataframe using tuples list DataFrame() method
5:18 Create dataframe using the list of dictionary DataFrame() method
6:34 Other ways to create dataframe

Next Video:
Python Pandas Tutorial 4: Read Write Excel CSV File

Popular Playlist:

#️⃣ Social Media #️⃣

[mahdikotti]

man your work quality is priceless !! short, very useful, with examples and informative videos !! the best way to learn python for data science !! keep up the good work and thanks a lot

[nickt]

This should save you some time! Here is the text he copied and pasted for examples 3 through 5

# way 3 (python dictionary)
weather_data = {
'day': ['1/1/2017', '1/2/2017', '1/3/2017'],
'temperature': [32, 35, 28],
'windspeed': [6, 7, 2],
'event': ['Rain', 'Sunny', 'Snow']
}


# way 4 (python tuple list)
weather_data = [
('1/1/2017', 32, 6, 'Rain'),
('1/2/2017', 35, 7, 'Sunny'),
('1/3/2017', 28, 2, 'Snow')
]

# way 5 (python dictionary list)
weather_data = [
{'day': '1/1/2017', 'temperature': 32, 'windspeed': 6, 'event': 'Rain'},
{'day': '1/2/2017', 'temperature': 35, 'windspeed': 7, 'event': 'Sunny'},
{'day': '1/3/2017', 'temperature': 28, 'windspeed': 2, 'event': 'Snow'}
]

[kevinzhang]

this is so far the best video for self-learning Python/Pandas ... thank you so much!

[shoaibrahman]

Man! Best tute I've ever seen on pandas. Lovely

[officesuperhero]

I agree with so many others here....your videos are truly top notch.

[venkatyalamati]

I got just impressed during first time watching your videos... but second time, I feel it's great!!!!

[ujjwalchetan]

Very methodical approach to teaching. Great. Thanks👍

[rajiyengar]

Great Tutorial. Can you list some tips if we need to productionalize this using Cloud environment - AWS/GCP/Azure? Thanks.

[skkkks]

Thank you for making the concept so easy and simple .I am worried about the people why gave "thumbs down" wishing if they know better let us know with the proof of video thumbs

[AbhijeetSingh-rxef]

what happens in the last one? how the system is interpreting that dates and events etc are column headings and need to be placed at the top only

[SriramM]

Excellent. I am not able to use read _excel() and it throws errors. I installed xlrd as per the error message, However no go

[vameghmirtalebi]

i will come back tommorow nice video ❤

[nemuccio]

Hello, what does the r before C: ?
df = pd.csv_read(r 'C:\datasets\example.csv')
With some letters of the lowercase alphabet from error if there is not.
thx
ric

[sabarishkavala]

Thank you for teaching me Basics of Pandas..

[alexkelso]

legend. this is amazing. Thanks for sharing!

[rajeshk]

This is a gr8 tutorial, i have one question, can we apply theses datafrmaes in spark ?

[cutebaby]

Thanks sir
There tutorials are really helpful

[satishkumar-irwy]

Hi Sir, can you help me to read multiple parquet files from different directories using python

[girishjahagirdar]

It's great tutorial.I have a question when I am using a large excel file all data is not displayed in jupyter notebook.How to make all data display. I have file wioth 200+ rows and 16 columns.In between it will show break with for two lines and continues

[chiragrathod]

Sir I'm not able to import excel and CSV. file the way you telling.i'm getting error like unicode error codec can't decode bytes in postinton 2-3: truncated\uxxxx escape.I have installed pandas
I have searched this error in Gogle and I got a solution such as use duplicate backlash, forwardlash and r" " still it's same error poping up
What's mistake have I been doing sir here