LAYA MARY JOY’s Post

Day 15 of My #M4aceLearningChallenge Today, I transitioned from NumPy into another powerful tool in data analysis — pandas. Introduction to Pandas Pandas is a Python library used for data manipulation and analysis. It is especially useful when working with structured data like tables (think Excel sheets or SQL tables). The two main data structures in pandas are: - Series → A one-dimensional array (like a single column) - DataFrame → A two-dimensional table (rows and columns) Getting Started: import pandas as pd Creating a Series: data = [10, 20, 30, 40] series = pd.Series(data) print(series) Creating a DataFrame: data = { "Name": ["Nasiff", "John", "Aisha"], "Age": [25, 30, 22] } df = pd.DataFrame(data) print(df) Why Pandas is Important: - Makes data easy to read and analyze - Handles large datasets efficiently - Provides powerful tools for cleaning and transforming data In real-world Machine Learning and Data Science projects, pandas is almost always one of the first tools used after collecting data. Tomorrow, I’ll dive deeper into reading datasets and exploring data using pandas 🚀 #MachineLearning #DataScience #Python #Pandas #M4aceLearningChallenge

Wednesday Data Tip: One thing I’m learning while working on data projects: Always question your data. Before trusting any result, I try to ask: • Where did this data come from? • Is it complete and accurate? • Are there missing values or inconsistencies? It’s easy to jump into analysis, but poor data quality leads to misleading insights. Good analysis starts with good data. Taking time to question and validate your data can prevent costly mistakes later. Still learning. Still building. #DataAnalytics #SQL #Python #DataQuality #LearningInPublic

👉 Most data analysis problems don’t start in SQL or Python — they start before that. From my experience working with real data, I discovered that the biggest challenge is not building models or dashboards. It’s understanding the data itself. When I took my first steps working with datasets, I was too focused on tools. - Python - SQL - Dashboards I would load a dataset, check the headers, and immediately start building something. But over time, I realized something important: 👉 The direction of your analysis is often already hidden in the data. For example, in financial reporting, a simple metric can be misleading if you don’t understand what’s behind it. A number might look correct — but without knowing how it’s calculated, what it includes, or what it excludes, you can easily draw the wrong conclusion. Now, before doing anything, I take time to: ✔️ explore the dataset ✔️ check distributions ✔️ question inconsistencies ✔️ understand what the data actually represents Because once you truly understand your data, the next steps become much clearer. 💡 Insight Good data work doesn’t start with tools. It starts with understanding. ❓Do you explore your data first, or jump straight into coding? #dataanalytics #python #sql #finance #analytics

Many people jump directly into tools when learning Data Analytics. SQL. Python. Power BI. But one thing changed my mindset completely: 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐢𝐬 𝐧𝐨𝐭 𝐚𝐛𝐨𝐮𝐭 𝐭𝐨𝐨𝐥𝐬. 𝐈𝐭’𝐬 𝐚𝐛𝐨𝐮𝐭 𝐬𝐨𝐥𝐯𝐢𝐧𝐠 𝐛𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐩𝐫𝐨𝐛𝐥𝐞𝐦𝐬. Tools are just the medium. The real value comes from:- • Understanding the problem • Asking the right questions • Finding patterns in data • Turning insights into decisions Tools can be learned in months. Thinking like an analyst takes practice. #dataanalytics #careergrowth #analytics #learningjourney

If you're stepping into Data Analytics, one question always comes up: SQL, Python, or Excel which one should I Learn? The answer isn't "one over the other"... it's understanding how they connect. Here's a simple way to think about it: • SQL Best for querying and extracting data from databases • Python (Pandas) Best for deeper analysis, transformations, and automation • Excel Best for quick analysis, reporting, and business-friendly insights What's interesting is that most core operations are actually the same across all three: • Filtering • Aggregation • Grouping • Sorting • Joining • Updating & combining data Only the syntax changes, not the logic. Once you understand the logic, switching between tools becomes much easier and that's what makes a strong data analyst. My takeaway: Don't just memorize syntax. Focus on concepts first. Because tools will change... but thinking in data will always stay relevant. Which one did you learn first SQL, Python, or Excel? 👇 Let's discuss! #DataAnalytics #SOL #Puthon #Excel #DataScience

Most people assume analytics is about finding answers. The harder skill is figuring out which questions are worth asking. When I started learning SQL and Python, I expected to feel like a complete beginner. I didn't, really. The instinct for spotting what doesn't add up — that came with me. This matters if you're mid-transition into analytics. Domain knowledge isn't separate from technical skill; it shapes how you read results. A dashboard built by someone who understands the process behind the numbers reads very differently from one that doesn't. SQL you can learn in a few months. The context for what a data point actually means? That takes years. What's one thing from your previous field that quietly made you better at working with data?

Here are 5 Python libraries I use every week that I never learned about in grad school. Not pandas. Not scikit-learn. The ones nobody tells you about until you're debugging something at 11 PM. 1. pydantic — I used to validate data with if-else chains. Now I define data models that catch bad records before they hit my pipeline. One config change saved me hours of debugging clinical data feeds. 2. missingno — One visualization that shows every missing value pattern in your dataset. In healthcare data, the pattern of what's missing matters more than the percentage. This library makes it obvious. 3. pandera — Schema validation for dataframes. Define what your columns should look like and it yells at you before bad data propagates downstream. Essential when your data comes from multiple sources. 4. rich — Better logging and console output. Sounds trivial. But when you're running a pipeline on a remote server and need to quickly understand what went wrong, pretty output saves real time. 5. janitor (pyjanitor) — Clean column names, remove empty rows, handle Excel messiness. The boring data cleaning that eats 30% of every project. What's a library that changed how you work? The more niche, the better. #Python #DataScience #MachineLearning

🚀 Day 25/100 — Getting Started with Pandas 🐍📊 Today I explored Pandas, one of the most powerful Python libraries for data analysis and manipulation. 📊 What I learned today: 🔹 Series & DataFrames → Core data structures 🔹 Reading datasets (read_csv) 🔹 Data inspection (head(), info(), describe()) 🔹 Filtering & selecting data 🔹 Handling missing values 💻 Skills I practiced: ✔ Loading real-world datasets ✔ Cleaning messy data ✔ Filtering rows & columns ✔ Basic data transformations 📌 Example Code: import pandas as pd # Load dataset df = pd.read_csv("data.csv") # View first rows print(df.head()) # Filter data filtered = df[df['sales'] > 1000] # Summary stats print(df.describe()) 📊 Key Learnings: 💡 Pandas makes data handling fast and efficient 💡 Data cleaning takes 70–80% of analysis time 💡 Understanding data is more important than coding 🔥 Example Insight: 👉 “Filtered high-value transactions (>1000) to identify premium customers” 🚀 Why this matters: Python + Pandas is a must-have skill for Data Analysts Used in: ✔ Data cleaning ✔ Data transformation ✔ Exploratory Data Analysis (EDA) 🔥 Pro Tip: 👉 Learn these first: groupby() merge() apply() ➡️ These are heavily used in real projects & interviews 📊 Tools Used: Python | Pandas ✅ Day 25 complete. 👉 Quick question: Have you started learning Pandas yet? #Day25 #100DaysOfData #Python #Pandas #DataAnalysis #DataCleaning #EDA #LearningInPublic #CareerGrowth #SingaporeJobs

🚀 Today’s Learning: Introduction to Pandas for Data Analysis Today I explored Pandas, one of the most powerful libraries in Python for data analysis 📊 Here’s what I learned: ✅ What is Pandas? Pandas is a Python library used for data manipulation and analysis, especially with structured data. 🔹 1. Data Loading import pandas as pd df = pd.read_csv('data.csv') # Load CSV df = pd.read_excel('data.xlsx') # Load Excel df = pd.read_json('data.json') # Load JSON 🔹 2. Exploratory Data Analysis (EDA) df.shape # (rows, columns) df.head() # First 5 rows df.info() # Data types & nulls df.describe() # Stats: mean, std, min, max df.value_counts() # Frequency of categories ✅ This helped me understand: 🔹 How to load real-world datasets 🔹 How to quickly explore and understand data 🔹 Basic statistics and structure of data This is a strong step towards data analysis and machine learning 🚀 Next, I’ll explore data cleaning and visualization 📊 #Python #Pandas #DataAnalysis #MachineLearning #LearningJourney # #DataScience

If you're stepping into Data Analytics, one question always comes up: 👉 SQL, Python, or Excel — which one should I learn? The answer isn’t “one over the other”… it’s understanding how they connect. Here’s a simple way to think about it: 🔹 SQL – Best for querying and extracting data from databases 🔹 Python (Pandas) – Best for deeper analysis, transformations, and automation 🔹 Excel – Best for quick analysis, reporting, and business-friendly insights What’s interesting is that most core operations are actually the same across all three: ✔ Filtering ✔ Aggregation ✔ Grouping ✔ Sorting ✔ Joining ✔ Updating & combining data Only the syntax changes, not the logic. Once you understand the logic, switching between tools becomes much easier — and that’s what makes a strong data analyst. 💡 My takeaway: Don’t just memorize syntax. Focus on concepts first. Because tools will change… but thinking in data will always stay relevant. Which one did you learn first — SQL, Python, or Excel? 👇 Let’s discuss! #DataAnalytics #SQL #Python #Excel #DataScience #LearningJourney