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 Artificial Intelligence from Data School 🤖

Join 25,000+ intelligent readers and receive AI tips every Tuesday!

Read more from Learn Artificial Intelligence from Data School 🤖

Hi Reader, A reader asked me the following question: I am now looking towards a new career. Machine Learning is what I've always found very interesting and fascinating. However, I'd like to ask you: Is there really future for this stuff with all the buzz about LLMs becoming more and more capable all the time? Would time be spent well on learning all this stuff? Read this article online Excellent question! As someone who just published a book on Machine Learning, I clearly believe there is...

Hi Reader, the response to my new Machine Learning book has been outstanding! 🤩 My goal with this book is to reach as many people as possible, which is why I’ve made it free to read online as well as keeping the paperback and ebook prices as low as possible. I’m confident it would be an invaluable resource for any Machine Learning bootcamp or course, since it's a highly practical guide as opposed to focusing mostly on theory. Do you have a personal contact at any bootcamp or university where...

Hi Reader, I'm thrilled to announce that my new book, Master Machine Learning with scikit-learn, is now on sale! Buy from Amazon I poured my heart and soul into making this the highest quality and most practical Machine Learning book available. Publishing this book is a dream come true, and I'd be grateful if you'd consider picking up a copy! 🙏 Option 1: Get the paperback from Amazon ($19) Although most technical books of this size (300+ pages) tend to sell for at least $39, I've priced the...