filmov
tv
Automate Excel reports with Python | Query database with Pandas | Split and save Dataframe to file
Показать описание
Excel is a powerful and widely used tool for data analysis. In this video, we will look at how to automate excel reports with Python. How to query a database and import data into a dataframe. Slice and dice this data in a dataframe. How to use OS module to create a directory structure and finally save the files in the directory.
SQL Server ODBC driver 11 for SQL Server for Windows
Command to install pyodbc package: pip install pyodbc
GitHub repo link for excel file, Notebook and SQL code
GitHub link for AdventureWorks2012 database file
How to install Pycharm IDE on windows:
Getting started with Jupyter Notebook:
Video Outline!
0:00 - Intro: business scenario
0:48 - Data Overview
1:50 - Import required libraries
2:40 - Create Database connection
3:40 - Importing the data used in this video
5:07 - Split dataframe per requirement
5:37 - Create Folder structure
7:29 - Execute code
SQL Server ODBC driver 11 for SQL Server for Windows
Command to install pyodbc package: pip install pyodbc
GitHub repo link for excel file, Notebook and SQL code
GitHub link for AdventureWorks2012 database file
How to install Pycharm IDE on windows:
Getting started with Jupyter Notebook:
Video Outline!
0:00 - Intro: business scenario
0:48 - Data Overview
1:50 - Import required libraries
2:40 - Create Database connection
3:40 - Importing the data used in this video
5:07 - Split dataframe per requirement
5:37 - Create Folder structure
7:29 - Execute code
0:12:52
Automate Excel Reporting Using Python (Real-Life-Example) | Pandas, Plotly, Xlwings Tutorial
0:07:19
Are You Still Using Excel? AUTOMATE it with PYTHON
0:38:02
Automate Excel With Python - Python Excel Tutorial (OpenPyXL)
0:06:01
Automate Excel Reporting with Python - Python Excel Tutorial
0:11:05
Automate Your Excel Tasks Using Python
0:10:57
How To Automate Excel Using Python | Combine Files & Create Charts 🤓
0:09:53
Automate Multiple Sheet Excel Reporting - Python Automation Tutorial | Full Code Walk Through (2019)
0:07:35
How to automate Data Analysis with Python? | Automate Excel | Automate Data Analysis | Python
0:06:56
Create and Distribute Excel Files using Python and Outlook | Automate Excel with Python
0:04:43
Automate Reports in Excel using Office Scripts - Time Saving Tip to Auto Format Reports
0:14:48
Automating Word Documents from Excel Using Python | ‘docxtpl’ Tutorial
0:12:40
Automate Excel With Python - How to Use Python in Spreadsheets
0:19:24
Automate Multiple Sheet Excel Reporting - Python Automation and Prediction | Full Code Walkthrough
0:09:22
Automate Excel | How to produce beautiful, well formatted reports with Python | Pandas | XlsxWriter
0:00:52
MS Excel - Macros - Automate your Spreadsheets in ONE CLICK!!
0:22:08
Automate Excel Reporting with Python! Combine Workbooks and Add Charts with Pandas and Openpyxl
0:08:53
Automate Excel reports with Python | Query database with Pandas | Split and save Dataframe to file
0:01:11
🚀 Automate Excel Reports with Python & Pandas (Part 5) 🚀
0:08:36
Automate Excel OS Reports with Python
0:02:45
Automating Excel Report with SQL, Python and Scheduler | Automate the daily tasks with Python
0:10:53
Use This Trick to Automate Any Excel Task (Better Than Macros)
0:00:46
AUTOMATE EXCEL USING CHATGPT
0:10:06
Automate Boring Office Tasks with ChatGPT and Python
0:29:21
Master Stock Analysis with Python and Yfinance: Automate Excel Reports in Minutes
Комментарии