Python Data Cleaning Cheat Sheet

How to "Slice the Cake" in Python? 🎂🐍 (Slicing & Indexing) Once you’ve learned how to store strings, the big question is: Do we always have to use the entire text? 🧐 The Answer: Absolutely not! Python gives us precision tools (Indexing & Slicing) that allow us to manipulate text data and extract exactly what we need. At Data Hub, we use this constantly during Data Cleaning. Whether you're extracting specific "Product Codes" from a long string or separating "Dates" to generate accurate reports, these tools are your best friends. 📊 1️⃣ Indexing (Finding the Address): Remember, Python starts counting from 0, not 1. If we have: word = "Python" Letter P is at index 0 Letter y is at index 1 Letter n is at index 5 (or -1 if you count from the end) 💡 Pro Tip: Negative indexing is a lifesaver when dealing with long strings where you only need the last few characters! 2️⃣ Slicing (Cutting the Data): To extract a specific "portion" of text, we use the slice operator [start : stop]. word[0:4] ➡️ Starts at index 0 and stops "before" index 4. Result: Pyth. word[:] ➡️ Leaving it empty selects the entire string from start to finish. word[-3:-1] ➡️ Starts 3 characters from the end and stops before the last one. Result: ho. 🧠 The Bottom Line: Index is the "Address" of the character, while Slicing is the "Scissors" that separates the data. Mastering these is your first step toward becoming a Data Analyst who handles data with speed and intelligence! 👌 💬 Weekly Challenge: If you have the variable: name = "DataHub" What should we write between the brackets [ : ] to extract only the word "Data"? Show me your answers in the comments! 👇 #Python #DataAnalysis #DataHub #PythonBasics #DataScience #LinkedInLearning #Programming #DataCleaning

Most people rush into Python for data analysis… But skip the foundation that actually makes them effective. This is where many get stuck. Before writing a single line of Python, ask yourself: Can you confidently work with data in SQL? Because these 6 concepts are not optional — they are the building blocks of real analysis: ✔ Joins – Can you combine datasets correctly? ✔ Aggregations – Can you summarize data meaningfully? ✔ Window Functions – Can you analyze trends over time? ✔ Subqueries & CTEs – Can you break down complex logic? ✔ Data Cleaning – Can you trust your data? ✔ Filtering Logic – Can you extract the right insights? Here’s the truth 👇 Python doesn’t replace these skills… it amplifies them. If your SQL foundation is weak, your Python analysis will also be weak. But if you master these? You don’t just analyze data — you think like a data professional. 💡 The real question is: Are you learning tools… or building analytical thinking? #DataAnalytics #SQL #Python #DataSkills #LearningJourney #AnalyticsMindset

Why does SQL feel harder than Python? 🤔 → Because it forces you to deal with reality. In Python/R: • Data is often already shaped • You focus mostly on analysis 🛠️📦 In SQL: • Data is fragmented across tables • You have to rebuild it before analyzing 🧩 And more importantly: → You see how your query impacts performance⚡💸 → You think about joins, structure, and efficiency → You start asking the right questions (more business-driven💼) That’s exactly what makes SQL so valuable in industry. It doesn’t just help you analyze data; it helps you understand how data is structured, how systems work, and how to think closer to real business problems. #DataAnalytics #DataScience #SQL #Python #BusinessIntelligence #DataAnalyst #DataScientist #Analytics #DataCareers

Python is a must-have skill for every Data Analyst. But knowing what to use is just as important as knowing Python itself. Here are some essential Python techniques I use while working with data 🔹 Explore data quickly with ".info()" & ".head()" 🔹 Handle missing values properly 🔹 Filter data using conditions 🔹 Group & summarize using "groupby()" 🔹 Merge datasets efficiently 🔹 Visualize insights clearly 🔹 Use "apply()" for quick transformations Clean data → Better insights → Better decisions Which one do you use the most? #Python #DataAnalytics #DataScience #Pandas #Analytics #Learning

I wrote just one line of Python code, and it worked. That’s when I realized something. Python is not just code, it’s instructions that bring ideas to life. Let me explain it like I’m explaining to a baby. Imagine you have a robot 🤖 You tell the robot: “Bring water” The robot follows your instruction step by step and that’s exactly what Python implementation is. What is Python Implementation? It simply means, writing instructions (code) And Python understands it Then executes it step by step For example, If I write, print("Hello, Precious") Python doesn’t argue. It doesn’t guess. It simply says, “Okay, let me display this.” And it shows, "Hello, Precious" But here’s what really blew my mind, Python doesn’t just run code. It reads it Interprets it Executes it immediately That’s why Python is called an interpreted language. Why this matters for Data Analysis As someone who have learn, Excel, SQL, Tableau and now Python I’m realizing that python is where everything comes together. Data cleaning, Data analysis, Automation, Visualization. All in one place. I used to think, “Learning tools is enough” Now I know that understanding how they work is the real power. If you’re learning Python or planning to, what was your first “aha” moment? Let’s talk 👇 #Python #DataAnalytics #LearningInPublic #SQL #Excel #Tableau #Programming #TechJourney #BeginnerInTech #DataScience #CareerGrowth

Excel or Python? Why Not Both! If you can think it in Excel, you can build it in Python. 💡 A lot of people think switching from spreadsheets to coding is a massive leap, but the truth is: the logic remains the same; only the tools change. Whether you are performing a simple XLOOKUP or building complex Pivot Tables, the underlying data principles are identical to using merge() or groupby() in Pandas. This cheat sheet breaks down the most common data tasks to show you exactly how to translate your Excel skills into Python code. Whether you are working in Finance, Economics, or Data Science, mastering both worlds makes you a powerhouse in any data project. 📈 Save this post for your next workflow, and let me know in the comments: Are you Team Excel or Team Python? 👇 #DataScience #Python #Excel #Pandas #DataAnalytics #Finomics #Automation #LearningEveryday

I wrote a function in Python, but nothing happened. I stared at my screen like: “Why is this thing not working?” 😅 Then I realized something simple, but powerful: I didn’t call it. Let me explain this like I’m talking to a baby Imagine you have a helper, you tell the helper: “When I say ‘clean’, go and clean the room.” That’s you creating a function. But here’s the catch If you don’t say “clean”, the helper will just stand there doing nothing 😂 That’s exactly what function invocation means in Python. You define a function (give instructions) You invoke (call) it to make it run Let's go with this code def greet(): print("Hello, Precious") greet() If you remove greet()… Nothing happens I used to think writing code was enough Now I understand that code only works when you tell it to run. As I move from excel, to SQL, to Tableau and now, Python I’m seeing that functions help you: Reuse your code Automate tasks Avoid repeating yourself Work faster with data Writing a function is like giving instructions Calling it is what brings it to life. If you're learning python, Have you ever written code and forgotten to call it? 😅 #Python #DataAnalytics #LearningInPublic #SQL #Excel #Tableau #Programming #TechJourney #BeginnerInTech #DataScience #CareerGrowth

Most analysts know SQL. Most analysts know Python. Very few know how to combine them efficiently. That’s why many stay average. Here are a few things I wish I learned earlier: In SQL: → WHERE cannot filter aggregated results If you're filtering grouped data, use HAVING. → Window functions save messy subqueries Use RANK(), ROW_NUMBER(), SUM() OVER() for ranking and running totals. → LAG() and LEAD() beat self-joins Comparing current vs previous period? One line does what multiple joins often can’t. In Python: → Do not load unnecessary data Filter in SQL before bringing it into pandas. → Avoid for loops in pandas Vectorized operations and apply functions are significantly faster. → Stop hardcoding dates Use datetime so your scripts stay dynamic and reusable. The real power comes when you combine both: → Pull data with SQL → Transform it in Python → Push results back with to_sql() That workflow alone will make you more efficient than most analysts around you. Knowing SQL or Python is useful. Knowing how to use both together is what separates strong analysts from average ones. #DataAnalytics #SQL #Python #AnalyticsEngineering #CareerGrowth

Python for Business Analytics 🧠📊 From raw data to meaningful insights — Python plays a powerful role in transforming complex and unstructured data into clear, actionable information. With its wide range of libraries and tools, Python enables data cleaning, analysis, visualization, and modeling, making it an essential skill in today’s data-driven business world. This mindmap represents how Python connects different aspects of business analytics — from collecting and processing data to generating insights that support smarter decision-making. It highlights how businesses can move from confusion and scattered data to structured analysis and strategic outcomes. Continuously learning and applying Python is not just about coding — it’s about developing the ability to think analytically, solve real-world problems, and create value through data. 📈💻 #python #pythonforbusinessanalytics #businessanalytics

🚀 Python Series – Day 10: Strings in Python (Text Handling Basics) Till now, we worked with numbers and collections. But what about text data? 🤔 👉 That’s where Strings come in! 🧠 What is a String? A string is a sequence of characters enclosed in quotes. ✔️ Can use single ' ' or double " " quotes 🔧 Example: name = "Mustaqeem" print(name) 🔁 Access Characters text = "Python" print(text[0]) # P print(text[-1]) # n ✂️ String Slicing text = "Python" print(text[0:3]) # Pyt print(text[2:]) # thon 🔄 String Methods msg = "hello world" print(msg.upper()) # HELLO WORLD print(msg.lower()) # hello world print(msg.title()) # Hello World ❌ Mutability Fails in String Strings are immutable — meaning you cannot change them directly. text = "Python" text[0] = "J" # ❌ Error 👉 This will give an error because strings cannot be modified. ✅ Correct Way (Create New String) text = "Python" new_text = "J" + text[1:] print(new_text) # Jython 🎯 Why Strings are Important? ✔️ Used in almost every program ✔️ Helps in user input & output ✔️ Important for data processing 🔥 Pro Tip: Whenever you want to modify a string 👉 create a new one instead of changing the original ⚡ Quick Challenge: What will be the output? text = "Python" print(text[1:4]) 👇 Comment your answer! 📌 Tomorrow: Dictionaries & Sets (Advanced Data Structures) Follow me to learn Python step-by-step from basics to advanced 🚀 #Python #DataScience #Coding #Programming #LearnPython #Beginners #Tech #MustaqeemSiddiqui