Skip to content

Python In Office

Use Python to automate office tasks

  • Home
  • About
  • Beginner
  • Intermediate
  • Advanced
  • Resources
  • Privacy Policy

Category: Beginner

How to create a pandas dataframe

September 2, 2020 Jay Beginner, machine learning, Python

We have seen many different ways to load data into Python using pandas, such as .read_csv() or .read_excel(). Those methods[…]

Read more

Sort Excel data using Python

September 1, 2020 Jay Beginner, machine learning, Office Automation, Python

Sorting table is a common task in Excel. We sort a table in order to help us view or use[…]

Read more

Split text to columns in Python

August 30, 2020 Jay Beginner, machine learning, Office Automation, Python

How many times have you had to split a text in Excel? I bet too many to count. Most Excel[…]

Read more

Remove duplicates from a data table

August 28, 2020 Jay Beginner, machine learning, Office Automation, Python

In Excel, we can “easily” remove duplicates from a table by clicking on the “Remove Duplicates” button from the Data[…]

Read more

Python list indexing and slicing

August 25, 2020 Jay Beginner, Python

I realize this is an important topic since we’ll be using these techniques a lot in pandas. Python list indexing[…]

Read more

Delete columns from a pandas dataframe

August 23, 2020 Jay Beginner, machine learning, Office Automation, Python

In this tutorial, we’ll learn how to drop/delete columns from a pandas dataframe. We are going to walk through three[…]

Read more

Delete rows from a dataframe

August 22, 2020 Jay Beginner, machine learning, Office Automation, Python

Deleting rows is a common task in Excel, in this tutorial, we’ll learn a few techniques to delete rows from[…]

Read more

How To Add A New Column in pandas DataFrame

August 21, 2020 Jay Beginner, machine learning, Office Automation, Python

In this tutorial, we’ll learn how to add a new column in pandas DataFrame. We are going to see a[…]

Read more

Get table data from web page using Python pandas

August 19, 2020 Jay Beginner, Office Automation, Python, Web Scraping

“I thought this blog talks about integrate Python with Excel stuff, why getting data from web???” Don’t be surprised when[…]

Read more

Get values, rows and columns in pandas dataframe

August 18, 2020 Jay Beginner, machine learning, Office Automation, Python

This article is part of the Transition from Excel to Python series. We have walked through the data i/o (reading[…]

Read more

Posts navigation

«Previous Posts 1 2 3 4 Next Posts»
Follow @jayzpio

Join our mailing list!

Recent Posts

  • I migrated my WordPress site from Bluehost to Linode
  • Stock Price Prediction with LSTM in Python
  • Building A Stable Diffusion Discord Bot
  • Python Closures
  • Building A Simple Python Discord Bot with DiscordPy in 2022/2023

Categories

  • Advanced
  • Beginner
  • Bot automation
  • Career Development
  • Computer Vision
  • data visualization
  • Database
  • Finance & Investing
  • Intermediate
  • machine learning
  • Office Automation
  • Python
  • R Programming
  • Web Scraping
WordPress Theme: Poseidon by ThemeZee.
Go to mobile version