Python Automation Series.
After completing this course, one can able to read/write data from excel and also able to learn to play 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 servers 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