Charan Kumar G’s Post

Task 1 completed ✅CodeAlpha I recently scraped a books dataset using Python + BeautifulSoup and the results were eye-opening. Here’s what the data revealed: 📖 Titles ranked from 1–5 stars 💷 Prices ranging across a wide spectrum ✅ Availability tracked in real time 🔗 Direct URLs saved for every book The top 5 highest-rated books? Led by Sapiens: A Brief History of Humankind — rated 5 stars at £54.23. Web scraping isn’t just a technical skill. It’s the ability to turn any website into structured, analyzable data — and that’s a superpower in today’s data-driven world. Here’s my workflow: 1️⃣ Scrape with requests + BeautifulSoup 2️⃣ Clean & structure with pandas 3️⃣ Analyze patterns (price vs. rating? availability trends?) 4️⃣ Export to CSV for further exploration If you’re learning Python or data science, web scraping is the project that makes everything click. 💡 What dataset would YOU scrape first? Drop it in the comments 👇 #Python #WebScraping #DataScience #Pandas #BeautifulSoup #100DaysOfCode #DataAnalytics #LearningInPublic

Day 4 — Python for Analytics When I started, I wasted weeks learning things I never used. Here are the 5 libraries that actually move the needle: 🐼 1. Pandas — The backbone of data analysis import pandas as pd df = pd.read_csv("sales_data.csv") top_product = (df.groupby("product")["revenue"]          .sum()          .sort_values(ascending=False)          .head(3)) print(top_product) If you learn nothing else — learn Pandas. 📊 2. Matplotlib / Seaborn — Turn numbers into stories Quick, beautiful charts with minimal code import seaborn as sns import matplotlib.pyplot as plt sns.lineplot(data=df, x="date", y="revenue") plt.title("Monthly Revenue Trend") plt.show() 🔢 3. NumPy — The engine under the hood Fast calculations on large datasets import numpy as np aov = np.mean(df["order_value"]) print(f"Average Order Value: ${aov:.2f}") 🤖 4. LangChain — Bridge between Python and LLMs Build GenAI workflows without starting from scratch from langchain_community.llms import OpenAI llm = OpenAI() response = llm("Summarize this sales report: ...") print(response) 📓 5. Jupyter Notebooks — Code + Story in one place Not just a coding tool — a communication format. Code → Output → Explanation → Chart All in one shareable document. Perfect for stakeholder walkthroughs. My honest learning path: Week 1 → Master Pandas Week 2 → Add Seaborn + Matplotlib Week 3 → Learn NumPy basics Week 4 → Explore LangChain Start with one. Build something real. Then add the next. #Python #Analytics #DataScience #Pandas #GenAI #30DayChallenge

I used to be really confused about NumPy and Pandas before/while learning them. They both seem similar at first. Here’s a simple way I understood them: 1. Numpy was built first (2005) to solve Python numerical problems. Python lists were slow for numerical work. And numpy made it faster and easier with C-based arrays. And when I learned about substitution, like you don't even have to use loops for those kinda tasks. 2. Pandas came later(2008) because Numpy was great with numbers, but real-world data is messy. So, to work with missing data and to work with other apps like Excel and SQL, it was created. The important part is that in most real projects, you don’t really choose one over the other; you use both together. Use NumPy when: 1. Working with pure numerical computations (linear algebra, mathematical operations) 2. Handling arrays, images, or signal data 3. You need performance and memory efficiency Use Pandas when: 1. Working with tabular or relational data (like Excel or SQL) 2. Dealing with missing or messy real-world data 3. Performing data cleaning, aggregation, or analysis 4. Working with time series data So in practice: NumPy handles the fast numerical backbone, and Pandas builds on top of it to make data handling more practical and readable. #pandas #numpy #NumpyVsPandas

Wrestling with data in Python and Pandas can feel like learning a new language every day, right? 🐍🐼 Ever find yourself constantly Googling the same syntax or searching for that perfect line of code? It's a time-sink, and honestly, a bit frustrating! Imagine having your most-used commands and functions at your fingertips. That's where a good cheat sheet comes in! 💡 Here's a peek at what belongs on yours: * **Data Loading:** `pd.read_csv()`, `pd.read_excel()` 📂 * **Inspection:** `.head()`, `.info()`, `.describe()`, `.shape` 🔍 * **Selection & Filtering:** `df[]`, `df.loc[]`, `df.iloc[]` 🎯 * **Handling Missing Values:** `.isnull().sum()`, `.dropna()`, `.fillna()` 🧹 * **Grouping & Aggregation:** `.groupby().agg()` 📊 * **Merging & Joining:** `pd.merge()`, `.join()` 🔗 * **Applying Functions:** `.apply()`, `.map()` ✨ A solid cheat sheet doesn't just save time; it empowers you to focus on the *insights*, not just the syntax. What's YOUR go-to Pandas function or Python snippet you'd put on your ultimate cheat sheet? Share your essential commands below! 👇 #Python #Pandas #DataScience #CheatSheet #Programming #DataAnalytics

Today I learned how to work with dates using to_datetime() in Pandas 📊🐍 In real-world datasets, dates are often stored as text. To analyze them properly, we need to convert them into datetime format. Example: df["date"] = pd.to_datetime(df["date"]) After conversion, we can easily extract: • Year • Month • Day df["year"] = df["date"].dt.year df["month"] = df["date"].dt.month df["day"] = df["date"].dt.day 💡 Why this is important? It helps in: • Time-based analysis • Trend analysis • Monthly/Yearly reporting Handling dates correctly is a key skill in Data Analytics. Step by step improving my practical knowledge in Python and Pandas 🚀 #Python #Pandas #DataAnalytics #LearningJourney #EDA

🐼 Pandas Preprocessing Cheat Sheet  A few years ago, I didn't know the difference between .isnull() and .isna() 😅 Now I'm building my own cheat sheets. I've been learning Data preprocessing with Python & Pandas — and honestly, the number of methods felt overwhelming at first. So I did what made sense: I started noting down every method I learned, with a simple example next to it. Over time, that list grew into a full reference sheet — 80+ methods covering: Here's a quick glance at the most important ones: 🔵 Missing Values → df.isnull().sum() — find nulls per column → df.fillna(df['col'].mean()) — fill with mean → df.dropna(subset=['col']) — drop specific nulls 🟢 Data Cleaning → df.drop_duplicates() — remove duplicate rows → df['col'].astype('category') — optimize memory → pd.to_numeric(df['col'], errors='coerce') — safe conversion 🟡 Exploration → df.describe() — instant stats summary → df['col'].value_counts() — frequency of each value → df.corr() — correlation between columns 🔴 Sorting & Filtering → df.sort_values('col', ascending=False) → df.nlargest(5, 'salary') — top 5 rows → df[df['age'] > 30] — filter by condition 🟣 GroupBy & Aggregation → df.groupby('dept')['salary'].mean() → df.pivot_table(values='salary', index='dept') ⚙️ Strings → df['col'].str.strip().str.lower() → df['col'].str.contains('keyword') I've compiled few with examples into a full cheat sheet Save this post for your next data interview! 🔖 #Python #Pandas #DataScience #MachineLearning #DataAnalysis #InterviewPrep #DataEngineering #100DaysOfCode #OpenToWork 👍

📊 Stationarity in Time Series — Practical Python Guide Most forecasting models (like ARIMA) require stationary data. Here’s a quick practical workflow to understand, test, and transform a time series. 🔹 1️⃣ Types of Stationarity • Strong Stationarity: Entire distribution stays the same over time (rare in real data). • Weak Stationarity: • Constant mean • Constant variance • Autocovariance depends only on lag 🔹 2️⃣ Visual Check (Rolling Statistics) 🔹 3️⃣ Statistical Tests 🔹 4️⃣ Making Time Series Stationary •Differencing •Log / Transformation •Detrending Git Repo:- https://lnkd.in/gqtwdXbm 🎯 Key Insight: Before building forecasting models, always test stationarity and transform the series if needed. Grateful to my mentor Ayushi Mishra for guiding me through practical time series concepts. #DataScience #TimeSeries #TimeSeriesAnalysis #Stationarity #ADFTest #KPSSTest #TimeSeriesForecasting #PythonForDataScience #Statistics #StatisticalModeling #MachineLearning #TechCommunity #AnalyticsCommunity #DataScientist #LearningInPublic

Ever opened a dataset and thought… “why is this so messy?” 😅 Same here. While working with Pandas, I realized data cleaning isn’t complicated — it’s just a few powerful steps repeated smartly 👇 🧹 Missing values? → isna() to find them, fillna() or dropna() to handle them 🔁 Duplicate rows? → drop_duplicates() and move on 🔧 Wrong data types breaking your logic? → astype() fixes it in seconds 🧼 Messy text (extra spaces, weird formats)? → str.strip() and str.lower() clean it instantly 📊 Before trusting data? → info() and value_counts() give a quick reality check Good analysis starts with clean data first. That simple shift has already changed how I look at datasets. Still learning, but this is one of the most useful lessons so far. #DataAnalytics #Python #Pandas #DataCleaning #LearningJourney

🐍 Most data analysts use Python. Few use it efficiently. Here are 8 tricks that will instantly level up your data analysis workflow. Each one saves time, reduces bugs, and makes your code actually readable 👇 🔍 Always start with these 3 lines df.info() # dtypes & nulls df.describe() # stats summary df.isnull().sum() # null count ⚡ Stop chaining filters — use query() # ❌ Messy df[df['age'] > 30][df['city'] == 'NYC'] # ✅ Clean df.query('age > 30 & city == "NYC"') 🔄 Never loop — vectorize everything # ❌ 100x slower for i in range(len(df)): df['rev'][i] = df['price'][i] * df['qty'][i] # ✅ Fast df['rev'] = df['price'] * df['qty'] 🧹 Clean data in 4 lines df.drop_duplicates(subset=['id'], inplace=True) df['age'].fillna(df['age'].median(), inplace=True) df['date'] = pd.to_datetime(df['date']) df.columns = df.columns.str.lower().str.replace(' ','_') 🚀 3 performance habits → Set dtype on import — cuts memory by 70% → Use chunksize for files too big for RAM → Use category dtype for string columns ♻️ Repost to help someone code smarter! #Python #Pandas #DataAnalysis #DataScience #NumPy #DataAnalyst #PythonTips #EDA #Analytics #100DaysOfCode #DataEngineering #TechTips

I finally experienced why analysts prefer #Python over Excel, and that’s when everything clicked. I was working with a messy real-world dataset. Inconsistent date formats, missing values across columns and duplicates hiding in plain sight. In Excel, this would have taken most of my morning. In Python, I cleaned it in under 20 lines. Here’s a snapshot of my workflow: ▪️ Dropped duplicates → df.drop_duplicates() ▪️ Handled missing values → df.fillna(0) / df.dropna() ▪️ Fixed date formats → pd.to_datetime(df["date"]) ▪️ Renamed messy columns → df.rename(columns={"Rev ": "revenue"}) ▪️ Filtered only what I needed → df[df["revenue"] > 1000] What surprised me most wasn’t the speed, it was the clarity. Each line tells a story of what’s happening to the data. You can read the logic from top to bottom like a recipe. I’m also starting to understand why experienced analysts emphasize 'reproducibility.' In Excel, if someone changes a cell, you may never know. In Python, everything is documented in the script, every transformation, every decision. That alone feels like a major shift in how I think about working with data. Still early in my journey, but my mindset is changing from 'how do I do this?' to 'how can I do this better?' #Python #DataAnalytics #DataCleaning #LearningInPublic