Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Python Automation Series
Rating: 4.2 out of 5(25 ratings)
2,727 students

Python Automation Series

Python Automation Series
Created byAditya Chandak
Last updated 10/2022
English

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

Course content

6 sections6 lectures1h 30m total length
  • Introduction5:36

    Learn Python automation for recurring data warehouse tasks. Read excel or csv files, connect to SQL Server, load data, and run procedures, all scheduled with Windows Task Scheduler.

Requirements

  • No programming experience needed.

Description

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


Who this course is for:

  • Beginners Python Course