Move from Excel to Python with Pandas Transcripts
Chapter: Data I/O (input and output)
Lecture: Reading Excel summary
0:00 cel files can be very messy,
0:01 fortunately, and as Redick cell function has a lot of options for reading in these
0:06 files and formatting it appropriately, for instance,
0:09 you can specify one or more worksheets to read it.
0:12 You can identify which header road to use.
0:14 You can specify certain columns to include.
0:17 If you need to parse dates,
0:19 you can use the par states function.
0:21 You can also force data types to make sure you preserve the data in the original
0:25 format, and then you can create custom converter functions to clean up the data.
0:30 I encourage you to use all the available options to clean and format data when reading
0:35 into your data frame so you can successfully complete your analysis.