Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 30 Minute(s)
Language
English
Taught by
Aditya Chandak
Rating
2 views
Course Overview
Python Automation Series
After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.
We have covered all the below things.
Read Data from Excel
Write Data from Excel
Read Specific sheet
Read specific cell
Write data
Sql Connectivity
Load Data in sql server
After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.
We have covered all the below things.
Read Data from Excel
Write Data from Excel
Read Specific sheet
Read specific cell
Write data
Sql Connectivity
Load Data in sql server
After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.
We have covered all the below things.
Read Data from Excel
Write Data from Excel
Read Specific sheet
Read specific cell
Write data
Sql Connectivity
Load Data in sql server
After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.
We have covered all the below things.
Read Data from Excel
Write Data from Excel
Read Specific sheet
Read specific cell
Write data
Sql Connectivity
Load Data in sql server
Course Content
- 6 section(s)
- 6 lecture(s)
- Section 1 Introduction
- Section 2 Read Write Data from Excel using Python
- Section 3 Read Write Data from multiple Excel sheets using Python
- Section 4 Import Excel data into Python using Pandas
- Section 5 Filter Rows and Columns Using Pandas
- Section 6 Import Data From Excel to SQL Server Python
What You’ll Learn
- Read and Write Data from Excel using Python
- Read Specific Row and Columns Using Python
- Read specific sheet using Python
- Load data from excel to database using Python
Skills covered in this course
Reviews
-
SShalaka Deshan
Good tutorial
-
KKunal M. Borkar
Nice content
-
aakash Chandak
Thank you for providing this Course. It is greate learning for beginners and intermediate level. I request you to put more session for the same.
