Mia Dwyer

AI

Exploring the Power of Natural Language Data Manipulation with PandasAI

How generative AI supercharges Pandas capabilities Mia Dwyer · Follow Published in Towards Data Science · 5 min read · 9 hours ago — I recently discovered a very intriguing new tool that marries my interest in data science and generative AI, which allows you to leverage ChatGPT to “talk” to your data directly in natural language while in a Jupyter notebook. Enter PandasAI 🐼✨ a free, open source Python library.* Image created by me,

Read More »
AI

How To Use Generative AI and Python to Create Designer Dummy Datasets

A Simple Guide for Practical Applications Mia Dwyer · Follow Published in Towards Data Science · 6 min read · 7 hours ago — Have you ever had a need for a dataset that doesn’t easily exist? Wanted to easily generate data that matches your exact requirements for interviewing prospective data science candidates, software testing + development, or training models? Or what about just wanting the right data to use to demonstrate skills + techniques

Read More »
AI

SQL Mastery: Advanced Techniques for Data Professionals

Elevating Your Data Skills with Window Functions, Regex, and CTEs Mia Dwyer · Follow Published in Towards Data Science · 6 min read · 1 day ago — During my tenure as a lead data analyst at Chime, three crucial SQL techniques— Window Functions, Regex, and CTEs — significantly advanced my capabilities, propelling me from intermediate proficiency to the expertise required for a lead analyst role. This article details these so you can up-level your

Read More »