Python Pandas Full Course | Learn in 6 hours | Pandas for Data Science and Analysis | Amit Thinks

[@Amit.Thinks]

The below lessons are explained in this 6 hour Pandas course:
1. Pandas - Introduction & Features 00:00:51
2. Install & Setup Pandas 00:03:43
3. Create a Pandas DataFrame (Run first program) 00:15:44
4. Pandas DataFrames - Attributes & Methods 00:34:05
5. Join Pandas DataFrame 00:57:45
6. Concatenate Pandas DataFrames 01:03:46
7. Create a Pandas Series 01:11:13
8. Pandas Series - Attributes & Methods 01:25:11
9. Combine two Pandas Series 01:49:08
10. Categorical Data in Pandas 01:56:23
11. Working with Categories in Pandas 02:05:20
12. Read CSV in Pandas 02:11:33
13. Read Excel in Pandas 02:24:28
14. Indexing in Pandas 02:39:06
15. Select multiple columns in Pandas 02:49:59
16. Add a new column in Pandas 03:00:51
17. Delete rows/ columns in Pandas 03:10:50
18. Iterate over rows and columns in Pandas 03:20:28
19. Sorting in Pandas 03:32:09
20. Handle Duplicates in Pandas 03:41:31
21. Clean the Data in Pandas 03:50:51
22. String Operations in Pandas 04:06:02
23. Date Time Operations in Pandas 04:25:02
24. Remove Whitespace or special character 04:42:57
25. Group the Data in Pandas 04:53:18
26. Statistical Functions in Pandas 05:12:14
27. Plot a DataFrame in Pandas 05:33:31
🔥NumPy Tutorial (English): ruclips.net/video/WsENswmSz6M/видео.html
🔥NumPy Tutorial (Hindi): ruclips.net/video/roqStVWNR7Q/видео.html
🔥Matplotlib Tutorial (English): ruclips.net/video/DFBkTIhptOQ/видео.html
🔥Matplotlib Tutorial (Hindi): ruclips.net/video/vBCXsAd_swk/видео.html
🔥Python Tutorial (English): ruclips.net/video/HakXpkXcjdI/видео.html
🔥Python Tutorial (Hindi): ruclips.net/video/b97WsOM9BYg/видео.html

[@renestevens9085]

Please i need to talk to you assp!
Thank you

[@Harshahub2023]

First comment
Sir Python for Data science course please making a video

[@Amit.Thinks]

Already uploaded. Free 5 courses for Data Science: bit.ly/3O7KfGk

[@sohailalip.r1626]

Thank you so much sir ❤❤

[@Amit.Thinks]

Most welcome. Refer to our other free courses:
Python Tutorial (English): ruclips.net/video/HakXpkXcjdI/видео.html
Python Tutorial (Hindi): ruclips.net/video/b97WsOM9BYg/видео.html
Pandas Tutorial (English): ruclips.net/video/yFoVs3_wvPo/видео.html
Pandas Tutorial (Hindi): ruclips.net/video/57POFzZ7f60/видео.html
NumPy Tutorial (English): ruclips.net/video/WsENswmSz6M/видео.html
NumPy Tutorial (Hindi): ruclips.net/video/roqStVWNR7Q/видео.html
Matplotlib Tutorial (English): ruclips.net/video/DFBkTIhptOQ/видео.html
Matplotlib Tutorial (Hindi): ruclips.net/video/vBCXsAd_swk/видео.html

[@ashokcdw]

Hi Amit, we can use python pandas for ETL Testing Automation(for validations) rite?

[@vijayjoshi-mw8cr]

Yes you can use pandas for ETL

[@xenovorans]

Thank you very much for all the shared and updated information :D

[@Amit.Thinks]

You're welcome. Also refer:
NumPy Tutorial: ruclips.net/video/WsENswmSz6M/видео.html
Matplotlib Tutorial: ruclips.net/video/DFBkTIhptOQ/видео.html

[@Ajeetkumar-tq9vb]

Student1 = {
'Student': ["Ajeet", "Ram", "Ajeet", "Ajay", "Sahil"],
'Rank': [1,2,3,4,5],
'Marks':[90, 80, 70, 60, 50]
}
ak = pd.DataFrame(Student1)
du = ak.duplicated()
0 False
1 False
2 False
3 False
4 False
dtype: bool
I don't know why all outputs are False

[@Amit.Thinks]

Because rows aren't duplicated.
Two Students with the name Ajeet. That's it. Check this code now:
import pandas as pd
Student1 = {
'Student': ["Ajeet", "Ram", "Ajeet", "Ajay", "Sahil"],
'Rank': [1,3,1,4,5],
'Marks':[90, 80, 90, 60, 50]
}
ak = pd.DataFrame(Student1)
du = ak.duplicated()
print(du)

[@akanshasharma1660]

Its showing tuple object is not callable. TypeError even if there's not any error.
print("student record
" , df)
Idk where the error

[@Amit.Thinks]

"TypeError" itself means there is an error. Kindly recheck the code.

[@ShahriyarHayatKhan]

Thank you so much !
Sir can you please send the ppt

[@Amit.Thinks]

I have provided the same ppt notes on my website: studyopedia.com/tutorials/pandas
Also, refer to our free courses:
Power BI Tuorial: ruclips.net/video/OITCW7ETz-M/видео.html
SQL Tutorial: ruclips.net/video/3mukGYjvixE/видео.html
Python Tutorial: bit.ly/3znnb1y
Pandas Tutorial: ruclips.net/video/yFoVs3_wvPo/видео.html
NumPy Tutorial: ruclips.net/video/WsENswmSz6M/видео.html
Matplotlib Tutorial: ruclips.net/video/DFBkTIhptOQ/видео.html
MySQL Tutorial: ruclips.net/video/sgpDAiF-18o/видео.html
MongoDB Tutorial: ruclips.net/video/cZ79avoq9UU/видео.html
HTML Tutorial: bit.ly/3VHaUvq
CSS Tutorial: bit.ly/3Khx5Ei
Bootstrap Tutorial: ruclips.net/video/nahewStckVU/видео.html

[@onlineaakashvani6145]

Thankyou Jay shree ram

[@Amit.Thinks]

Welcome! Refer our other Python Tutorials:
Python Tutorial (English): ruclips.net/video/HakXpkXcjdI/видео.html
Python Tutorial (Hindi): ruclips.net/video/b97WsOM9BYg/видео.html
NumPy Tutorial (English): ruclips.net/video/WsENswmSz6M/видео.html
NumPy Tutorial (Hindi): ruclips.net/video/roqStVWNR7Q/видео.html
Matplotlib Tutorial (English): ruclips.net/video/DFBkTIhptOQ/видео.html
Matplotlib Tutorial (Hindi): ruclips.net/video/vBCXsAd_swk/видео.html

[@iliepegza2948]

You are the best

[@SahilKumar-xk6bg]

Thanks Sir

[@Amit.Thinks]

You'r welcome, Sahil. Refer the following free tutorials:
Python Tutorial (English): ruclips.net/video/HakXpkXcjdI/видео.html
Python Tutorial (Hindi): ruclips.net/video/b97WsOM9BYg/видео.html
NumPy Tutorial (English): ruclips.net/video/WsENswmSz6M/видео.html
NumPy Tutorial (Hindi): ruclips.net/video/roqStVWNR7Q/видео.html
Matplotlib Tutorial (English): ruclips.net/video/DFBkTIhptOQ/видео.html
Matplotlib Tutorial (Hindi): ruclips.net/video/vBCXsAd_swk/видео.html

[@AbdirahmanAbdull-gs1wr]

Thanks your help me prother.

[@Amit.Thinks]

Glad to hear that. Refer to our other free courses:
NumPy Tutorial: ruclips.net/video/WsENswmSz6M/видео.html
Matplotlib Tutorial: ruclips.net/video/DFBkTIhptOQ/видео.html
ChatGPT Tutorial: ruclips.net/video/6E8tw6_4tMQ/видео.html

[@AshanSuranjana-ff3nw]

❤❤❤

[@Amit.Thinks]

Check our free 5 courses for Data Science: bit.ly/3O7KfGk

[@shoaibalam7126]

itni english aati hoti toa freecode camp se na perh letay

[@Amit.Thinks]

Hahaha! Bhai, same course in Hindi: 🙂
Pandas Tutorial (Hindi): ruclips.net/video/57POFzZ7f60/видео.html
Aur bheju Hindi courses?
Video Description mein sab hai bhai…

[@MadhusudhanreddyBapathu]

Please remove subtitles, I am getting irritating

[@Amit.Thinks]

So, you don't know how to switch off the subtitles?
Click on the "Settings" gear icon on the video player and click "Off".

[@MadhusudhanreddyBapathu]

@@Amit.Thinks Thanks

[@Amit.Thinks]

You're welcome. All our free courses:
docs.google.com/document/d/1-QY5N2Cq2tjMbSMo1WPMKZ-ju2MnDWkF/

[@MadhusudhanreddyBapathu]

@@Amit.Thinks Thanks