A Guide to Writing Python with AI

This will be an overview of the tools you can use to write Python automatically with AI. OpenAI Codex This is the most widely used code generation tool. It relies on Chat GPT-3 to generate code that the user prompts with written words. For example, as the website’s documentation

Wall Street's Transition from Excel to Python

No, Spreadsheets Are not Going Away The common first question I get is “why do you think Python can eat Excel”? This is the wrong approach, in my opinion. Python is not going to eat Excel – it is too foundational (large parts of the global economy depend on spreadsheets – not

5 Lessons Learned from Adding ChatGPT to a Mature Product

Last month, Mito launched v1 of Mito AI. To be totally honest with you, it’s not the world’s best AI feature (yet). We wanted to get something out the door so that our users could start exploring, and so that we could start learning. V2 of Mito AI

Python Basics #4: Pandas

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

Under Excel's Thumb: Reasons for Excel’s Dominance

It’s a supremely underrated fact that Excel is the most-widely used piece of consumer software outside of a web-browser, and has been so for the past 40 years or so. Simply put, Excel is one of the most dominant pieces of software of all time. What can explain this

Python Basics #3: Functions

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.

Merging Dataframes

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

Python Basics #2: Variables

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. Now, it's time to understand

Python Basics #1: Hello World

Welcome to the exciting and powerful world of Python. If you’re here, you probably have at least one of these Excel files in your life: 1. The too big for its own good: This Excel file has so much data in it that it takes 10 minutes to open

Add a Column to a Pandas Dataframe

Adding a column to a pandas dataframe allows you to create new and useful calculations from existing data in your dataframe. The code you probably want Adding a new column to the end of the dataframe and setting it equal to a transformation of existing columns. import pandas as pd