Move from Excel to Python with Pandas Transcripts
Chapter: Data I/O (input and output)
Lecture: Reading Excel summary

Login or purchase this course to watch this video and the rest of the course contents.
0:00 cel files can be very messy, fortunately, and as Redick cell function has a lot of options for reading in these
0:07 files and formatting it appropriately, for instance, you can specify one or more worksheets to read it. You can identify which header road to use.
0:15 You can specify certain columns to include. If you need to parse dates, you can use the par states function.
0:22 You can also force data types to make sure you preserve the data in the original
0:26 format, and then you can create custom converter functions to clean up the data.
0:31 I encourage you to use all the available options to clean and format data when reading
0:36 into your data frame so you can successfully complete your analysis.

Talk Python's Mastodon Michael Kennedy's Mastodon