Published in


3 Python Packages That Make Data Science Simple


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 install
python -m jupyter lab

Here is a link to the full install instructions.

Mito is a great package for slicing and dicing your data. Mito allows the users to create interactive pivot tables and graphs with just a few clicks.

Mito pivot tables are a great way to see relationships between different variables and group the data in a way that makes insights more apparent.

You can configure a Mito pivot table by selecting the Pivot button from the toolbar and then choosing your rows, columns, values and aggregation types.

Each edit in Mito generates the equivalent Python in the code cell below. It is a much faster way of producing code than constantly heading to Stack Overflow to find the correct syntax.

The pivot table above generates this code and auto-comments it as well!

Mito does not just generate the code for pivot tables. In Mito, you can merge datasets, filter, sort, use functions, look at summary statistics, and more — and Mito will generate the equivalent Python for each of these edits.

Mito also allows the users to generate dynamic Plotly charts without any coding required. Plotly is an amazing Python graphing package.

To create a Plotly chart, all the user has to do is click the graph button and select their axes.

Here is Mito’s full documentation.

2.Pandas Profiling

Pandas Profiling takes the df.describe() function from Pandas and elaborates on the functionality, providing amazing summary information for a dataframe quickly and efficiently.

Pandas Profiling is a great tool for exploratory data analysis.

You can install the package locally with these commands:

import sys
!{sys.executable} -m pip install -U pandas-profiling[notebook]
!jupyter nbextension enable --py widgetsnbextension

Pandas Profiling provides advanced summary statistics and information for a dataset with out having to write very much code at all.

Here it the full description of the Pandas Profiling functionality, as described on the documentation website:

Two really powerful features are the reports on Missing Values and Descriptive Statistics. When analyzing a new dataset, handling missing values can be a pain. Pandas Profiling makes this process much easier. The descriptive statistics are great for understanding the dataset more in depth before proceeding in your analysis.


Lux is a great package for visualizing data. The tedium of getting the code exactly correct to make the chart you want can be a large time sink. Lux recommends graphs for you, that you can select with a click of a button.

Lux can be applied to any dataframe and will automatically suggest graphs that the user can choose from.

The users can also use the intent function to pass in the columns they are interested in exploring and Lux will automatically suggest graphs.

Lux can be installed with a simple line of Python:

**pip install lux-api**

I hope these packages are helpful. If you have any comments or questions, please leave a reply — or reach out to me: :)




The first spreadsheet that generates Python that corresponds to your edits. Check us out at

Recommended from Medium

Translate Business problems to Data science problems.

The Basics of NumPy in Data Science

The Powerful Limits of Central Limits in Prediction

Searching places and their geographic details for geoanalytics

Applying Machine Learning to Build a More Resilient World

What Data Science Taught Me About Writing

A quick glance at Depth First Search

Mastering Tableau 2021: How to handle Null Values

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Jake from Mito

Jake from Mito

Exploring the future of Python and Spreadsheets

More from Medium

Top 3 Python Packages for Data Cleaning

Pandas in action “how to automate your data analysis process”

7 Python libraries that Data Science Beginner should know

All about Python — 100 + Code Snippets, Tricks, Concepts and Important Modules