In this tutorial, we’ll use Python’s Pandas and Numpy library to replace many Excel functions you probably used in the past.

Use Pandas and Numpy to ditch Excel forever.

As someone who has been working with Excel for many years, I know that the idea of learning things you can already do in Excel/VBA in a completely new environment like Python doesn’t sound so exciting. However, all the benefits that the Python environment offers make this worth it. For this reason, I came up with a useful and simple guide I wish I had when I switched from Excel to Python.

In this article, we’ll use Python’s Pandas and Numpy library to replace many Excel functions you probably used in the past.

**Table of Contents**

1. The Dataset

2. Sum, Average, Max, Min, Count

Columns (e.g. sum a column)

Rows (e.g. sum a row)

3. IF

Replace IF with np.where

Replace nested IF with np.select

4. SumIf, CountIf, AverageIf

One condition (select a column with square brackets [ ] )

Two or more conditions (select columns and use & or |)

5. Basic Data Cleaning

Change the case of text with .str.lower, .str.upper or .str.title

Extract text in a column with .str.extract

Identify whether a cell is empty with the .isnull method

6. Vlookup

Find an element with .loc[ ]

Merge two tables with pd.merge or pd.concat

7. Pivot Table

Use the .pivot_table method

8. Replace Excel Graphs with Python’s Matplotlib or Seaborn

🔵 Intellipaat Data Science with Python course: https://intellipaat.com/python-for-data-science-training/In this Data Science With Python Training video, you...

Python tutorial for Data Science - Learn Python, Pandas, NumPy, Matplotlib, will take you from knowing nothing about Python to coding and analyzing data with Python using tools like Pandas, NumPy, and matplotlib. This is a hands-on course and you will practice everything you learn step-by-step.

This free 12-hour Python Data Science course will take you from knowing nothing about Python to being able to analyze data. You'll learn basic Python, along with powerful tools like Pandas, NumPy, and Matplotlib. This is a hands-on course and you will practice everything you learn step-by-step. This course includes a full codebase for your reference [https://github.com/datapublishings/Course-python-data-science]. It kicks off with a one-hour introduction to basic programming concepts, proble

In Conversation With Dr Suman Sanyal, NIIT University,he shares his insights on how universities can contribute to this highly promising sector and what aspirants can do to build a successful data science career.

Enroll in our Data Science with Python training in Chennai. Best Data Science with Python Training courses in Chennai for 100% Job Placements Support.