• Latest
  • Trending
Spreadsheet that Generates Python: The JupyterLab Extension

Spreadsheet that Generates Python: The JupyterLab Extension

January 4, 2022
Apple is reportedly testing iPhones with USB-C

Apple is reportedly testing iPhones with USB-C

May 16, 2022
Nintendo Working on Next-Gen Switch Powered by an NVIDIA SoC

Nintendo Working on Next-Gen Switch Powered by an NVIDIA SoC

May 16, 2022
AMD Instinct MI300 Exascale APU Features Zen4 CPU and CDNA3 GPU

AMD Instinct MI300 Exascale APU Features Zen4 CPU and CDNA3 GPU

May 16, 2022
GrAI Matter Labs Unveils sparsity-native AI SoC

GrAI Matter Labs Unveils sparsity-native AI SoC

May 16, 2022
Tecnotree Launches a Transformation Suite for MTN Ghana

Tecnotree Launches a Transformation Suite for MTN Ghana

May 16, 2022
Ghana with Moringa School and Brighter Investment to promote digital skills for jobs

Ghana with Moringa School and Brighter Investment to promote digital skills for jobs

May 16, 2022
SA Obscure Technologies announces strategic alliance with DNSSense

SA Obscure Technologies announces strategic alliance with DNSSense

May 16, 2022
SLVA Cybersecurity to provide crucial new API security solutions

SLVA Cybersecurity to provide crucial new API security solutions

May 16, 2022
Samsung PRO Endurance Up to 256GB microSD Memory Card

Samsung PRO Endurance Up to 256GB microSD Memory Card

May 16, 2022
Apacer AS2280Q4U M.2 PCIe Gen4 x4 NVMe 1.4 for PS5

Apacer AS2280Q4U M.2 PCIe Gen4 x4 NVMe 1.4 for PS5

May 16, 2022
ProGrade Digital SDXC UHS-II V90 512GB U3 Memory Card

ProGrade Digital SDXC UHS-II V90 512GB U3 Memory Card

May 16, 2022
Team Group T-Force Vulcan Z SATA 2.5-Inch With 3D TLC Flash

Team Group T-Force Vulcan Z SATA 2.5-Inch With 3D TLC Flash

May 16, 2022
  • Consumer Watch
  • Kids Page
  • Directory
  • Events
  • Reviews
Monday, 16 May, 2022
  • Login
itechnewsonline.com
  • Home
  • Tech
  • Africa Tech
  • InfoSEC
  • Data Science
  • Data Storage
  • Business
  • Opinion
Subscription
Advertise
No Result
View All Result
itechnewsonline.com
No Result
View All Result

Spreadsheet that Generates Python: The JupyterLab Extension

by ITECHNEWS
January 4, 2022
in Data Science, Leading Stories
0 0
0
Spreadsheet that Generates Python: The JupyterLab Extension

Mito is a spreadsheet interface for Python

 
 
Mito allows you to pass your dataframes or CSV files into a spreadsheet interface. It has the feel of Excel, but each edit generates the equivalent Python in the code cell below. At its best, this can be a really fast way to get your data analysis done.

Exploratory Data Analysis with Mito

Getting Started With Mito

 
 
Here are the full installation instructions.

YOU MAY ALSO LIKE

Apple is reportedly testing iPhones with USB-C

Nintendo Working on Next-Gen Switch Powered by an NVIDIA SoC

To install the Mito package, run these commands in your terminal:

python -m pip install mitoinstaller
python -m mitoinstaller install

Then open a notebook in Jupyter Lab and call a mitosheet:

import mitosheet
mitosheet.sheet()

The Mitosheet can be called at any point in your analysis. You can pass in dataframes to the mitosheet as an argument in the sheet call.

mitosheet.sheet(df)

You can install pass in data from your local files with the import button.

Mito Data Analysis Features

 
 
Mito offers a range of features that allow the users to clean, wrangle and explore their data. Each of these features generates the equivalent Python in the code cell below.

Within Mito, you can:

  • Filter
  • Pivot
  • Merge
  • Graph
  • Look at summary statistics
  • Use Spreadsheet Formulas
  • and more…

For each of these edits, Mito generates Pandas code in the code cell below, that the user can carry forward in their analysis or send to a colleague.

Here is what it looks like to make a pivot table with Mito:

Pivot table with Mito (Visualization made by author)

Example generated pivot table code looks like this (the code is auto-documented):

# Pivoted ramen_ratings_csv into df3
unused_columns = ramen_ratings_csv.columns.difference(set(['Style']).union(set(['Brand'])).union(set({'Style'})))
tmp_df = ramen_ratings_csv.drop(unused_columns, axis=1)
pivot_table = tmp_df.pivot_table(
    index=['Style'],
    columns=['Brand'],
    values=['Style'],
    aggfunc={'Style': ['count']}
)# Flatten the column headers
pivot_table.columns = [flatten_column_header(col) for col in pivot_table.columns.values]

Here is the process for looking at summary statistics about a column:

Summary statistics with Mito (Vizualization made by author)

Generating Visualization Code

 
 
Getting the syntax correct for python data visualizations can be a time-consuming process. Mito allows you to generate graphs in a point and click environment and then gives you the equivalent code for those graphs.

Once you create a graph, click the copy graph code button:

Making graphs with Mito (Image made by author)

Then paste the code in any code cell. Mito allows for a reproducible visualization process.

Mito generates code (Image made by author)

Conclusion

 
 
Mito is a fast way to generate Python code, especially for those familiar with Excel. It saves a lot of time on going to Stack Overflow or Google for correct syntax.

Mito is definitely worth a try, though it will be even more valuable as they introduce more graph types and a better ability for bulk editing (bulk column deletion, renaming etc.).

Tags: JupyterLab ExtensionPython
ShareTweetShare

Get real time update about this post categories directly on your device, subscribe now.

Unsubscribe

Search

No Result
View All Result

Recent News

Apple is reportedly testing iPhones with USB-C

Apple is reportedly testing iPhones with USB-C

May 16, 2022
Nintendo Working on Next-Gen Switch Powered by an NVIDIA SoC

Nintendo Working on Next-Gen Switch Powered by an NVIDIA SoC

May 16, 2022
AMD Instinct MI300 Exascale APU Features Zen4 CPU and CDNA3 GPU

AMD Instinct MI300 Exascale APU Features Zen4 CPU and CDNA3 GPU

May 16, 2022

About What We Do

itechnewsonline.com

We bring you the best Premium Tech News.

Recent News With Image

Apple is reportedly testing iPhones with USB-C

Apple is reportedly testing iPhones with USB-C

May 16, 2022
Nintendo Working on Next-Gen Switch Powered by an NVIDIA SoC

Nintendo Working on Next-Gen Switch Powered by an NVIDIA SoC

May 16, 2022

Recent News

  • Apple is reportedly testing iPhones with USB-C May 16, 2022
  • Nintendo Working on Next-Gen Switch Powered by an NVIDIA SoC May 16, 2022
  • AMD Instinct MI300 Exascale APU Features Zen4 CPU and CDNA3 GPU May 16, 2022
  • GrAI Matter Labs Unveils sparsity-native AI SoC May 16, 2022
  • Home
  • InfoSec
  • Opinion
  • Africa Tech
  • Data Storage

© 2021 iTechNewsOnline.Com - Powered by BackUpDataSystems

No Result
View All Result
  • Home
  • Tech
  • Africa Tech
  • InfoSEC
  • Data Science
  • Data Storage
  • Business
  • Opinion

© 2021 iTechNewsOnline.Com - Powered by BackUpDataSystems

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In

Add New Playlist

Are you sure want to unlock this post?
Unlock left : 0
Are you sure want to cancel subscription?
Go to mobile version