Skip to content

Python In Office

Use Python to automate office tasks

Home
About
Beginner
Intermediate
Advanced

Month: March 2020

large-elephant

How to open large csv or text files

March 27, 2020 Jay Beginner, Data Manipulation, Excel, Python

The Problem If you work with Excel, at some point, you probably have tried to open large csv or text[…]

Read more

many-files

Use Python to combine multiple Excel files into one master spreadsheet

March 26, 2020 Jay Beginner, Data Manipulation, Excel, Python

In this short tutorial, I’ll show you how to use Python to combine multiple Excel files into one master spreadsheet.[…]

Read more

Search for:

Join our mailing list!

First Name

Email address:

Leave this field empty if you're human:

Recent Posts

How To Connect And Work With SQLite Database Using Python sqlite3
How To Connect And Work With MS Access Database Using Python pyodbc
Create Free Audiobooks! – Convert Text To Audio In Python
Freeze Your Python Code – How to Run Python Script Without Python Installed
How To Gain More Insights By Summarizing Data With Python Pandas Groupby Function

Recent Comments

Jay on Use fuzzy string matching in pandas
Jay on Use fuzzy string matching in pandas
eureka boss smart vac ultra on Use fuzzy string matching in pandas
Roy on Use fuzzy string matching in pandas
bursa escort on Use fuzzy string matching in pandas

Archives

September 2021
April 2021
March 2021
February 2021
November 2020
September 2020
August 2020
July 2020
May 2020
April 2020
March 2020

Categories

Advanced
Beginner
Data Manipulation
Database
Excel
Intermediate
Outlook
pandas
PDF
Python
Web Scraping
xlwings

Meta

Register
Log in
Entries feed
Comments feed
WordPress.org

WordPress Theme: Poseidon by ThemeZee.