This is post four in our series Python Basics, where we discuss the minimum Python and Jupyter you need to know to successfully automate Excel reports using Mito. Read Post One: Hello World, Post Two: Variables, and Post Three: Functions. So far, we’ve used variables to hold individual values, for…

This is post three in our series Python Basics, where we discuss the minimum Python and Jupyter you need to know to successfully automate Excel reports using Mito. Read Post One: Hello World and Post Two: Variables. In the last post, we learned that variables are containers that hold values…

It is inevitable: spreadsheets users will have their workflows drastically altered by programming languages like Python. Spreadsheets are brilliant pieces of software. They are flexible, visual, and easy to use, a trifecta that most software does not have. As data sizes become larger and the need for scalable analyses grows…

This is post two in our series Python Basics, where we discuss the minimum Python and Jupyter you need to know to successfully automate Excel reports using Mito. Read post one here. In the last post, we wrote our first piece of code. …

1.Mito Mito is a spreadsheet front-end for Python. You can call Mito into your Jupyter Notebook and each edit you make in the front-end will generate the equivalent Python. Here is a video demo: To install Mito, use these three commands: python -m pip install mitoinstaller python -m mitoinstaller…

If you concatenate two dataframes, a new dataframe will be created with the rows of the first dataframe above the rows of the second dataframe. The code you probably want To concatenate two dataframes while keeping only the columns they share: import pandas as pd df1 = pd.DataFrame({'A': [1, 2], 'B': ['a', 'b']}) df2 = pd.DataFrame({'A': [3…

Merging dataframes allows you to combine multiple data sources into one. In the data world, enriching data often includes merging two datasets together. These datasets can be similar or different. Pandas is a great way to do this in a few lines of code. Below you’ll find easy “copy and…

Pivot tables are the classic requirement on a job posting that you learn the day before the interview. Nobody uses them until you need them, and then they become your best friend. Pivot tables were first featured in Lotus, the precursor to Excel, and then became popularized in Excel 5. …

Exploratory Data Analysis (EDA) can be an essential part of your data science process. I want to emphasize the work “can”. I’ve seen many people expand their EDA process to a point of overkill. Of course there are always more patterns to be found, but you need to build a…