Aishwarya Nevrekar Profile picture
May 3, 2023 8 tweets 4 min read Read on X
Master data cleaning in pandas like a pro with these simple functions.

Data cleaning is a critical step in any data analysis project

Learn to clean messy datasets with these easy steps.

A thread🧵👇 Image
In pandas, you can use functions like .dropna(), .fillna(), and .replace() to clean up your data.

For example, let's say you have a data frame with missing values like this: Image
1. The .dropna() function removes any rows with missing values.

For example, you can use df.dropna() to drop any rows with missing values from your data frame called "df": ImageImage
2. The .fillna() function replaces missing values with a specified value.

For example, you can use df.fillna(0) to replace any missing values in your data frame called "df" with 0: ImageImage
3. The .replace() function replaces specified values with another value.

For example, you can use df.replace('Yes', 'True') to replace all instances of 'Yes' in your data frame called "df" with 'True': ImageImage
4. Use functions like .str.lower() and .str.upper() to convert string values to lowercase or uppercase, respectively.

For example, you can use df['City'].str.lower() to convert all values in the 'City' column of your data frame to lowercase: ImageImage
With these simple functions, you can quickly and easily clean up your data in pandas and prepare it for analysis! #pandas #datacleaning #datascience
Thank you so much for reading this, for more follow @nevrekaraishwa2

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Aishwarya Nevrekar

Aishwarya Nevrekar Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @nevrekaraishwa2

Dec 18, 2024
Mastering SQL isn't just about learning concepts; it's about solving problems. 🧩
Here’s a curated list of the best platforms to practice SQL and sharpen your skills.

A thread🧵👇
1. LeetCode
Ideal for SQL problems ranging from easy to hard, especially for interview prep.
🔗 leetcode.com/problemset/dat…
2. HackerRank
Comprehensive SQL practice tracks with challenges for all skill levels.
🔗 hackerrank.com/domains/tutori…
Read 10 tweets
Dec 31, 2023
Free Data Analyst Learning Path from Google

A thread 🧵👇 Image
Read 14 tweets
Oct 13, 2023
This is going to change Data Analytics!

A spreadsheet inside the Notebook which also generates Pandas code.

This makes Data Analysis easy for All!

A thread 🧵👇
@tryMito is designed to simplify complex data tasks.

It offers a user-friendly interface to streamline data processing, visualization, and collaboration, making it an invaluable asset for data scientists.
It is built on:
🐍 Jupyter
📷 Streamlit
📷 Python
Read 6 tweets
May 28, 2023
Learn NumPy using this cheat sheet.
A thread 🧵👇 Image
Image
Image
Read 5 tweets
May 25, 2023
📑💼 Free Resume Guide for Data Analysts: Crafting an Impressive Data-Driven Resume! 📊🔍
A thread 🧵👇 Image
1️⃣ Hello aspiring data analysts!
🌟 In this thread, we'll explore a comprehensive guide to help you create a standout resume that showcases your skills and experiences in the field of data analysis. Let's dive in and make your resume shine! 💼💡
2️⃣ Key tips for your resume:
📝 Start with a Summary Statement: Introduce yourself and your goals concisely.
📚 Highlight Relevant Skills: Emphasize technical skills like SQL, Python, and data visualization.
🎓 Showcase Education: Include degrees, certifications, or courses.
Read 8 tweets
May 25, 2023
Learn Django for free 🤑🤑🤑.
Today, let's talk about Django tutorials for beginners in simple terms and why learning Django can be super helpful for you.
Let's get started! 💻🚀
A thread🧵👇
1.
2.
Read 7 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(