How To Add A New Column in pandas DataFrame
In this tutorial, we’ll learn how to add a new column in pandas DataFrame. We are going to see a[…]
Read moreCategory: Office Automation
We provide a series of tutorials on how to automate office tasks such as data manipulation in Excel, sending Outlook emails, or creating Word documents.
Insert rows into a dataframe (vs Excel table)
One common task in Excel is to insert rows into a sheet. When working with data in Python, we can[…]
Read moreGet table data from web page using Python pandas
“I thought this blog talks about integrate Python with Excel stuff, why getting data from web???” Don’t be surprised when[…]
Read moreGet values, rows and columns in pandas dataframe
This article is part of the Transition from Excel to Python series. We have walked through the data i/o (reading[…]
Read moreSave multiple sheets to one Excel file in Python
This short article is part of the Transition from Excel to Python series. Last time we learned how to save[…]
Read moreSave data to an Excel file using Python
We have already learned how to read data from Excel files. Another important thing to know is how to save[…]
Read moreRead multiple Excel files into Python
We discussed how to read data from a single Excel file. Next we’ll learn how to read multiple Excel files[…]
Read moreRead multiple Excel sheets with Python pandas
In the previous post, we touched on how to read an Excel file into Python. Here we’ll attempt to read[…]
Read more
Use Excel and Python together
Magic happens when you use Excel and Python together. Let me put this out first: I love Excel, and I[…]
Read more
Integrate Python with Excel – from zero to hero
LAST UPDATED: Nov 08 2021 When I first started this blog, I had one idea in mind – to share[…]
Read more