How to Generate Pandas Code with LLM Tools like ChatGPT

What Is Pandas? Pandas is an open source Python package most commonly used for data analysis. Wes Mckinney created pandas, while at a hedge fund named AQR capital, so it is not a coincidence that Pandas is often used in financial services for data analysis. Pandas allows users to work

Mito AI For Enterprise: Bring Your Own Model

Mito AI has been live for less than a month, and since then we’ve watched our open source users use it in incredibly creative ways. Our users have used Mito AI to work around limitations in our product, do complex transformations with a single request, optimize their scripts, and

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