Tuesday Tip #41: Profile your pandas DataFrame 🔎


Hi Reader,

I just published a new blog post, Get started with conda environments. If you’re new to virtual environments in Python, give it a read!

Once you start using virtual environments, you’ll wonder how you ever got along without them!


🔗 Link of the week

Yann LeCun on the future of AI (Lex Fridman interview)

Yann LeCun is one of the “godfathers of Deep Learning”, the Chief AI Scientist at Meta, and (in my opinion) one of the clearest and most convincing thinkers on the future of AI.

It’s a long interview (2 hr 45 min), and some of the sections are highly technical, so use the timestamps to jump to the parts that interest you most.

Lex is a world-class interviewer and an AI researcher, and he was the perfect person to conduct this conversation. Highly recommended!


👉 Tip #41: Profile your pandas DataFrame in one line of code

Let’s say that you’ve got a new dataset you want to quickly explore without too much work. Here’s what to do:

Step 1: Install ydata-profiling

Step 2: Import ydata_profiling in Jupyter

Step 3: Run the ProfileReport() function and pass it any DataFrame

Voilà! It returns an interactive report in HTML format.

The report’s first section is an overview of the dataset and a list of possible issues with the data:

The second section gives a summary of each column:

The third section lets you explore feature interactions:

The fourth section visualizes missing values:

And the final section shows a sample of the dataset:

Want more tricks like this? Check out My top 25 pandas tricks on YouTube (250K+ views), or enroll in my new course, pandas in 30 days!


👋 See you next Tuesday!

Did you like this week’s tip? Please forward it to a friend or share this link with your favorite online community. It really helps me out! 🙌

- Kevin

P.S. How This Guy Makes the World’s Best Puzzle Boxes (WIRED video)

Did someone AWESOME forward you this email? Sign up here to receive Data Science tips every week!

Learn Data Science from Data School 📊

Join 25,000+ aspiring Data Scientists and receive Python & Data Science tips every Tuesday!

Read more from Learn Data Science from Data School 📊

Hi Reader, Last week, I announced that a new course is coming soon and invited you to guess the topic. Hundreds of guesses were submitted, and four people who guessed correctly got the course for free! (I've already notified the winners.) I'll tell you about the course next week. In the meantime, I've got a new Tuesday Tip for you! 👇 🔗 Link of the week OpenAI just unleashed an alien of extraordinary ability (Understanding AI) If you're curious about what makes OpenAI's new "o1" models so...

Hi Reader, I'm really proud of this week's tip because it covers a topic (data leakage) that took me years to fully understand. 🧠 It's one of those times when I feel like I'm truly contributing to the collective wisdom by distilling complex ideas into an approachable format. 💡 You can read the tip below 👇 or on my blog. 🔗 Link of the week Building an AI Coach to Help Tame My Monkey Mind (Eugene Yan) In this short post, Eugene describes his experiences calling an LLM on the phone for coaching:...

Hi Reader, Last week, I recorded the FINAL 28 LESSONS 🎉 for my upcoming course, Master Machine Learning with scikit-learn. That's why you didn't hear from me last week! 😅 I edited one of those 28 videos and posted it on YouTube. That video is today's tip, which I'll tell you about below! 👉 Tip #45: How to read the scikit-learn documentation In order to become truly proficient with scikit-learn, you need to be able to read the documentation. In this video lesson, I’ll walk you through the five...