Read Excel Files In Pandas

Опубликовано: 18 Июль 2022
на канале: Analytics School

1,268

In this session, you’ll learn how to use Python and Pandas to read Excel files using the Pandas read_excel method. Excel files are everywhere – and while they may not be the ideal data type for many data analysts, knowing how to work with them is an essential skill. In this session you will learn, how to use the Pandas read_excel method to read an excel file, read specific excel sheet to read in pandas, read multiple excel sheet using read_excel method in pandas, read certain columns from an excel file in pandas, and more.

Chapters:

00:00 - Introduction
00:35 - Install either XLRD or OpenPyXl
01:10 - About superstore dataset
02:03 - Read superstore dataset using read_excel method
03:03 - Read 'Returns' sheet using 'sheet_name' parameter
05:30 - Read all sheets in an excel file
07:31 - Read specific columns from an excel file
09:12 - Specify data types for columns
11:32 - Read only 'N' observations

#dataanalysis #analytics #dataanalytics #pandaspythontutorial #excel #analyticsschool