- 90
- 89 076
Data Automation
เข้าร่วมเมื่อ 3 ก.ย. 2022
This channel is dedicated to providing easy to follow, simple Python coding videos wherein I cover one topic at a time.
😄 Please consider supporting this channel and making this content possible - It would be greatly appreciated! This channel is run by one person who produces these videos on the side. They require subscription costs and time to create.
☕ www.buymeacoffee.com/DataAutomation
🅿 www.patreon.com/DataAutomation
😄 Please consider supporting this channel and making this content possible - It would be greatly appreciated! This channel is run by one person who produces these videos on the side. They require subscription costs and time to create.
☕ www.buymeacoffee.com/DataAutomation
🅿 www.patreon.com/DataAutomation
xlwings - Changing Text Color in an Excel Workbook with Python | Data Automation
This video reviews how to change the color of text in an Excel workbook using the xlwings Python library. I use Anaconda's Jupyter Lab interface.
😄 Please consider supporting this channel and making this content possible:
☕ www.buymeacoffee.com/DataAutomation
🅿 www.patreon.com/DataAutomation
00:00 :: Intro & Workbook Review
00:32 :: Changing One and Multiple Cell Colors
02:51 :: Overview
#PythonExcelTutorial #openpyxl #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #data #jupyterlab #colors #textcolor
😄 Please consider supporting this channel and making this content possible:
☕ www.buymeacoffee.com/DataAutomation
🅿 www.patreon.com/DataAutomation
00:00 :: Intro & Workbook Review
00:32 :: Changing One and Multiple Cell Colors
02:51 :: Overview
#PythonExcelTutorial #openpyxl #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #data #jupyterlab #colors #textcolor
มุมมอง: 15
วีดีโอ
OpenPyXL - Remove All Pivot Tables from an Excel Worksheet with Python | Data Automation
มุมมอง 6619 ชั่วโมงที่ผ่านมา
This video reviews how to remove all Data Validations in an Excel Worksheet using the Python library Openpyxl. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation 00:00 :: Intro and Workbook Review 00:58 :: Removing Pivot Table Format 02:34 :: Removing Pivot Tab...
Password Protect Excel Workbooks with Python using win32com | Data Automation
มุมมอง 8214 วันที่ผ่านมา
This video reviews how to pass word protect an excel document by using the win32com python library. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation 00:00 :: Intro and Workbook review 00:59 :: Open Application and Assign Password 03:36 :: Overview #PythonExce...
xlwings - XLOOKUP an Entire Column in an Excel Workbook with Python | Data Automation
มุมมอง 23621 วันที่ผ่านมา
This video reviews how to add the XLOOKUP formula to an entire column using the Python library xlwings. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation 00:00 :: Intro and Workbook review 00:33 :: Collecting Last Row of Data 01:33 :: Adding XLOOKUP to the Col...
OpenPyXL - Changing Line Chart Colors in Excel Workbooks with Python | Data Automation
มุมมอง 7628 วันที่ผ่านมา
This video reviews how to change the line colors in a line chart in an excel workbook using the Python library Openpyxl. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation To see the video on how to make a line chart, visit: th-cam.com/video/oorQfM_lOF8/w-d-xo....
OpenPyXL - Whole Number Data Validation in Excel Workbooks with Python | Data Automation
มุมมอง 110หลายเดือนก่อน
This video describes how to add a whole number data validation restriction to a cell in an excel workbook using the Python library Openpyxl. It also shows how to add error and input messages. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation 00:00 :: Intro and...
xlwings - INDEX / MATCH an Entire Column in an Excel Workbook with Python | Data Automation
มุมมอง 154หลายเดือนก่อน
This video reviews how to add the INDEX / MATCH formula pair to an entire column using the Python library xlwings. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation 00:00 :: Intro and Workbook review 00:28 :: Collecting Last Row of Data 01:39 :: Adding INDEX M...
OpenPyXL - Format a Cell as a Percentage in an Excel Worksheet with Python | Data Automation
มุมมอง 162หลายเดือนก่อน
This video reviews how to format a cell as a Percent in an Excel Worksheet using the Python library Openpyxl. It goes over decimals, whole numbers, and what happens when you try to impose a percentage on a string of text. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/Dat...
OpenPyXL - Remove All Conditional Formatting from an Excel Worksheet with Python | Data Automation
มุมมอง 149หลายเดือนก่อน
This video reviews how to remove all Conditional Formatting in an Excel Worksheet using the Python library Openpyxl. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation 00:00 :: Intro and Workbook Review 01:04 :: Reviewing Conditional Formats 01:59 :: Removing D...
PyPDF2 - Merging/Combining Multiple PDFs into One | Data Automation
มุมมอง 552 หลายเดือนก่อน
This video shows how to combine multiple pdfs into a single one using the Python library PyPDF2. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation 00:00 :: Intro and PDF Review 01:05 :: Create PDF Writer 01:29 :: Collecting all PDFs 03:00 :: Creating the Final...
xlwings - Creating Line Charts in Excel Workbooks with Python | Data Automation
มุมมอง 1312 หลายเดือนก่อน
This video demonstrates how to create line charts using the xlwings Python library. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation 00:00 :: Intro and Workbook Review 00:31 :: Creating and Adding the Chart 02:19 :: Overview #PythonExcelTutorial #xlwings #dat...
OpenPyXL - Change the Options in a Dropdown List in Excel Workbooks with Python | Data Automation
มุมมอง 1032 หลายเดือนก่อน
This video reviews how to use Python's library OpenPyXL to change the options provided in a Data Validation List object in an Excel Workbook. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation 00:00 :: Intro and Workbook Review 00:37 :: Reviewing our Data Valid...
OpenPyXL - Move an Excel Sheet to Another Workbook with Python | Data Automation
มุมมอง 1482 หลายเดือนก่อน
This video demonstrates how to move an excel sheet from one workbook to another by using the Python library OpenPyXL. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation 00:00 :: Intro and Workbook review 00:50 :: Checking Out Worksheets 01:12 :: Trying _add_she...
xlwings - Adding Images to an Excel Workbook with Python | Data Automation
มุมมอง 1133 หลายเดือนก่อน
This video reviews how to add images to an excel workbook use the Python library xlwings. I use Anaconda's Jupyter Lab interface. In the cell where I import os.path, I inadvertently use "os.path.abspath" to collect the path of the photo when I should have just used the "abspath" function I clearly imported in the line above. Minor error in code, but functionally nothing changes. 😄 Please consid...
OpenPyXL - Methods to Clear an Entire Excel Worksheet of Content with Python | Data Automation
มุมมอง 2173 หลายเดือนก่อน
This video reviews three separate ways to remove all of the content on an Excel Worksheet using the Python library Openpyxl. I use Anaconda's Jupyter Lab interface. 😄 Please consider supporting this channel and making this content possible: ☕ www.buymeacoffee.com/DataAutomation 🅿 www.patreon.com/DataAutomation Deleting and Inserting Columns and Rows: th-cam.com/video/ZoR3AfIUB0k/w-d-xo.html 00:...
OpenPyXL - Create a Customized Dark Mode Excel Workbook Report with Python | Data Automation
มุมมอง 3633 หลายเดือนก่อน
OpenPyXL - Create a Customized Dark Mode Excel Workbook Report with Python | Data Automation
OpenPyXL - XLOOKUP an Entire Column across Multiple Excel Workbooks with Python | Data Automation
มุมมอง 2563 หลายเดือนก่อน
OpenPyXL - XLOOKUP an Entire Column across Multiple Excel Workbooks with Python | Data Automation
xlwings - Group & Ungroup Columns & Rows in an Excel Workbook with Python | Data Automation
มุมมอง 1474 หลายเดือนก่อน
xlwings - Group & Ungroup Columns & Rows in an Excel Workbook with Python | Data Automation
OpenPyXL - Find and Replace in an Excel Workbook with Python | Data Automation
มุมมอง 2674 หลายเดือนก่อน
OpenPyXL - Find and Replace in an Excel Workbook with Python | Data Automation
xlwings - VLOOKUP an Entire Column in an Excel Workbook with Python | Data Automation
มุมมอง 2444 หลายเดือนก่อน
xlwings - VLOOKUP an Entire Column in an Excel Workbook with Python | Data Automation
Tabula - Read Tables into Dataframes from a PDF with Python | Data Automation
มุมมอง 6984 หลายเดือนก่อน
Tabula - Read Tables into Dataframes from a PDF with Python | Data Automation
xlwings - Merging & Unmerging in Excel Workbooks with Python | Data Automation
มุมมอง 1215 หลายเดือนก่อน
xlwings - Merging & Unmerging in Excel Workbooks with Python | Data Automation
OpenPyXL - Copy a Column to a Different Worksheet in Excel Workbooks with Python | Data Automation
มุมมอง 4045 หลายเดือนก่อน
OpenPyXL - Copy a Column to a Different Worksheet in Excel Workbooks with Python | Data Automation
OpenPyXL - Reading the Options in a Dropdown List in Excel Workbooks with Python | Data Automation
มุมมอง 4355 หลายเดือนก่อน
OpenPyXL - Reading the Options in a Dropdown List in Excel Workbooks with Python | Data Automation
OpenPyXL - Copy a Column in Excel Workbooks with Python | Data Automation
มุมมอง 2735 หลายเดือนก่อน
OpenPyXL - Copy a Column in Excel Workbooks with Python | Data Automation
xlwings - Insert & Delete Columns & Rows in Excel Workbooks with Python | Data Automation
มุมมอง 4315 หลายเดือนก่อน
xlwings - Insert & Delete Columns & Rows in Excel Workbooks with Python | Data Automation
OpenPyXL - Download an Image from an Excel Workbook with Python | Data Automation
มุมมอง 3926 หลายเดือนก่อน
OpenPyXL - Download an Image from an Excel Workbook with Python | Data Automation
xlwings - Adjusting Column Width in Excel Workbooks with Python | Data Automation
มุมมอง 2116 หลายเดือนก่อน
xlwings - Adjusting Column Width in Excel Workbooks with Python | Data Automation
OpenPyXL - Moving an Entire Row in Excel Workbooks with Python | Data Automation
มุมมอง 2476 หลายเดือนก่อน
OpenPyXL - Moving an Entire Row in Excel Workbooks with Python | Data Automation
OpenPyXL - XLOOKUP an Entire Column across Multiple Tabs in Excel with Python | Data Automation
มุมมอง 1156 หลายเดือนก่อน
OpenPyXL - XLOOKUP an Entire Column across Multiple Tabs in Excel with Python | Data Automation