Python Pandas Data Science Tutorial (Read CSV/Excel, add/delete columns, Filter, Groupby, Slice)

In this Python Pandas tutorial we will cover basics of dataframe. DataFrame is a main object of pandas. It is the go-to library for data analysis and data science. The effective data analysis requires the ability to extract, clean, reshape, index, slice and summarize data. If you are familiar with data warehousing term ETL, extract, transform and load we can perform all these steps with Pandas. I will cover all of these topics with examples in this session.

Data & code used in this Tutorial: https://github.com/hnawaz007/pythondataanalysis/tree/main/Pandas
Python Pandas Documentation: https://pandas.pydata.org/pandas-docs/stable/

Set up Python and Jupyter Environment: https://www.youtube.com/watch?v=B0G-44dqHRM

Let me know if you have any questions!

If you enjoyed this video, be sure to like and make sure to subscribe to not miss any future videos!

Thanks for watching friends!
Happy coding! 🙂

———————————————
Follow me on social media!

Subscribe: https://www.youtube.com/c/HaqNawaz
Github: https://github.com/hnawaz007
Instagram: https://www.instagram.com/bi_insights_inc
LinkedIn: https://www.linkedin.com/in/haq-nawaz/

———————————————

#Python #Coding #DataScience #Pandas #PythonPandas #Python #PythonTutorial #PythonTraining #PythonBeginners #Anaconda #JupyterNotebook

Topics covered in this video:
0:00 – Intro to Pandas
2:49 – Jupyter Notebook UI
4:15 – Install Pandas
5:17 – Loading the data into Pandas DataFrame
6:21 – Examine Data (Check, Columns, Cells, Headers, Rename columns)
12:29 – Handle missing value and data conversion
14:11 – Getting rows based on a specific condition
15:35 – Data Stats (Unique, Sum, Count)
16:55 – Slice Dataframe (Loc)
22:01 – Iterate Over Dataframe rows
24:36 – Adding a calculated column
27:38 – Dataframe iLoc
33:03 – Adding a column
33:51 – Deleting a column
34:24 – Grouping and summarizing data
35:02 – Top Ten Product report
35:30 – Transaction count by category
35:54 – Create pivot tables
36:32 – Saving our Data (CSV, Excel)

source by BI Insights Inc

python tutorial

Mourad ELGORMA

Fondateur de summarynetworks, passionné des nouvelles technologies et des métiers de Réseautique , Master en réseaux et système de télécommunications. ,j’ai affaire à Pascal, Delphi, Java, MATLAB, php …Connaissance du protocole TCP / IP, des applications Ethernet, des WLAN …Planification, installation et dépannage de problèmes de réseau informatique……Installez, configurez et dépannez les périphériques Cisco IOS. Surveillez les performances du réseau et isolez les défaillances du réseau. VLANs, protocoles de routage (RIPv2, EIGRP, OSPF.)…..Manipuler des systèmes embarqués (matériel et logiciel ex: Beaglebone Black)…Linux (Ubuntu, kali, serveur Mandriva Fedora, …). Microsoft (Windows, Windows Server 2003). ……Paquet tracer, GNS3, VMware Workstation, Virtual Box, Filezilla (client / serveur), EasyPhp, serveur Wamp,Le système de gestion WORDPRESS………Installation des caméras de surveillance ( technologie hikvision DVR………..). ,

Laisser un commentaire