A Complete Guide to Move From Excel to Python

A Complete Guide to Move From Excel to Python

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

data-science python excel numpy pandas

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Data Science With Python Training | Python Data Science Course | Intellipaat

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

Python for Data Science - Learn Python, Pandas, NumPy, Matplotlib

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.

Python Data Science – A Free 12-Hour Course for Beginners. Learn Pandas, NumPy, Matplotlib

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

How To Build A Data Science Career In 2021

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.

Data Science with Python Certification Training in Chennai

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