read_excel(): Data from Excel to Pandas DataFrame #B01

00:00 Introduction
00:18 Data Formats for importing and exporting to DataFrame
01:06 Visual studio Code platform to use pandas read_excel() to create DataFrame
02:16 Sample excel file ( student table )
02:30 Colab Platform to read excel file and create DataFrame
04:38 sheet_name to read from work sheet
06:00 index_col specify the column to be used as Index of the DataFrame
07:15 header of the columns
08:45 names , header names
09:42 uscols , Using columns to create DataFrame
11:25 dtype , updating data type of the column
13:00 converters, applying functions to elements of the DataFrame
16:50 skiprows , skip rows while creating DataFrame
20:00 nrows , use number of rows to create DataFrame
20:19 skipfooter, skip rows from the footer while creating DataFrame

#read_excel() #DataFrameFunctions #ExcelToDataFrame #ImportData #plus2net #Tutorial


Download all Jupiter file ( .ipynb ) with source code
https://www.plus2net.com/python/pandas.php

Copy or download Excel file or sample DataFrame of student table
https://www.plus2net.com/python/pandas-student.php

Copy or read all source codes and answer sample questions from here
https://www.plus2net.com/python/pandas-read_excel.php


More about Colab platform
https://www.plus2net.com/python/colab.php

Upload Excel or CSV file to Colab platform ( mount drive ) and use with Pandas
https://youtu.be/4u59d9np7Rk



Course Details
https://www.plus2net.com/courses.php#pandas



Web site: www.plus2net.com
YouTube: https://www.youtube.com/@plus2net1
Facebook: https://www.facebook.com/plus2net
Instagram: https://www.instagram.com/plus2net.in/
LinkedIn: https://www.linkedin.com/in/plus2net/
Write to us https://www.plus2net.com/contactus.php

Тэги:

#read_excel() #Excel_file_to_DataFrame

Скачать видео