Reading Files in Pandas | Python Pandas Tutorials
Learn how to read various file formats using Pandas in Python. This tutorial covers essential techniques for data loading and preprocessing in data analysis workflows.

Alex The Analyst
279.4K views • Feb 28, 2023

About this video
Take my Full Python Course Here: https://www.analystbuilder.com/courses/pandas-for-data-analysis
In this series we will be walking through everything you need to know to get started in Pandas! In this video, we learn about Reading in Files in Pandas.
Datasets in GitHub:
CSV - https://bit.ly/3CH1h8E
TXT - https://bit.ly/3RGqm7X
JSON - https://bit.ly/3RMvJTk
EXCEL - https://bit.ly/3ClvRmW
Code in GitHub: https://github.com/AlexTheAnalyst/PandasYouTubeSeries/blob/main/Pandas%20101%20-%20Reading%20in%20Files.ipynb
Favorite Pandas Course:
Data Analysis with Pandas and Python - https://bit.ly/3KHMLlu
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
📖Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX
📖Statistics for Data Science - https://bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
📖Tableau A-Z - http://bit.ly/385lYvN
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
https://www.youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: https://github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
0:00 Intro
0:58 Read in CSV File
7:39 Read in Txt File
8:53 Read in JSON File
9:32 Read in Excel File
11:30 Looking at Max Rows/Columns
13:35 Looking at Data in DataFrame
18:05 Outro
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
In this series we will be walking through everything you need to know to get started in Pandas! In this video, we learn about Reading in Files in Pandas.
Datasets in GitHub:
CSV - https://bit.ly/3CH1h8E
TXT - https://bit.ly/3RGqm7X
JSON - https://bit.ly/3RMvJTk
EXCEL - https://bit.ly/3ClvRmW
Code in GitHub: https://github.com/AlexTheAnalyst/PandasYouTubeSeries/blob/main/Pandas%20101%20-%20Reading%20in%20Files.ipynb
Favorite Pandas Course:
Data Analysis with Pandas and Python - https://bit.ly/3KHMLlu
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
📖Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX
📖Statistics for Data Science - https://bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
📖Tableau A-Z - http://bit.ly/385lYvN
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
https://www.youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: https://github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
0:00 Intro
0:58 Read in CSV File
7:39 Read in Txt File
8:53 Read in JSON File
9:32 Read in Excel File
11:30 Looking at Max Rows/Columns
13:35 Looking at Data in DataFrame
18:05 Outro
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
279.4K
Likes
4.5K
Duration
19:17
Published
Feb 28, 2023
User Reviews
4.7
(55) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.