Learning Python basics for data analytics

Daily Progress — Python + SQL Today, I practiced some simple but powerful Python basics: 🔹 input() function 🔹 Data types 🔹 String conversion and len() 🔹 Conditional statements (if-else) 🔹 String replacement using .replace() Python Practice: Age = 323 x = len(str(Age)) if x < 2:   print("Yes, it is") else:   print(x, "- No, it is not") phone_Num = "123-475-886" print(phone_Num.replace("-", "/")) And to make sure I don’t forget SQL while learning Python, I practiced one query today as well WITH CTE AS (  SELECT    s.Category,   SUM(s.Price * s.Quantity) AS Total_Revenue,   SUM(s.Quantity * p.Cost) AS Total_Cost  FROM Sales AS s  INNER JOIN Products AS p    ON s.Product_Name = p.Product_Name  GROUP BY s.Category ) SELECT   Category,  Total_Revenue,  Total_Cost,  (Total_Revenue - Total_Cost) AS Total_Profit FROM CTE ORDER BY Category, Total_Profit DESC; Lesson learned: Small consistent practice builds long-term mastery. #Python #SQL #DataAnalytics #LearningJourney #DataScience #AI #CodingEveryday #Consistency

Handling Missing Data in Python — Made Simple! 🐍 Ever opened a dataset and saw NaN or blank cells everywhere? 😩 Don’t worry — missing values (or nulls) are super common in data analysis. But the good news? Python makes handling them really easy! 💪 Here are some quick and simple ways 👇 🔹 1️⃣ Check for missing values df.isnull().sum() 👉 Helps you see how many null values each column has. 🔹 2️⃣ Remove missing values df.dropna(inplace=True) 👉 Use this if you’re okay losing those rows. 🔹 3️⃣ Fill missing values df['column_name'].fillna(value, inplace=True) 👉 Replace nulls with mean, median, mode — or even 0! Example: df['Age'].fillna(df['Age'].mean(), inplace=True) 🔹 4️⃣ Forward or backward fill df.fillna(method='ffill', inplace=True) 👉 Fills missing values using previous data. 💡 Pro tip: Never just drop or fill without understanding why the data is missing — sometimes, missing info can tell its own story! 📊 Data cleaning = foundation of good analysis. Because if your data is messy, your insights will be too! 😉 #Python #DataAnalysis #DataCleaning #Pandas #LearningData #DataScience #MachineLearning #CareerInData #UAEJobs #DataWithProvin

Learning to Clean Data with Python When I first started working with data, I thought cleaning it would be the easy part. Just fix a few typos and move on. I was wrong. My first experience cleaning data in Python opened my eyes to how messy real-world data can be. I had to deal with: Duplicate entries that distorted results, Missing values that made columns incomplete, and Extra spaces and inconsistent text formats that quietly broke analyses. Using tools like Pandas, I learned to write simple but powerful commands to make the data usable again — drop_duplicates(), fillna(), strip(), and a few others quickly became my best friends. It reminded me so much of my time in data entry, where accuracy was everything. The difference is that, with Python, I wasn’t just typing data, I was transforming it into something clean, structured, and ready for insight. That experience taught me a valuable lesson: Before you can trust your data, you must clean your data. Now, every time I start a new project, I approach raw data with patience and a good cup of coffee. #DataCleaning #Python #DataScience #LearningJourney #Pandas #WednesdayMotivation

Writing a for-loop in Python to process a list of data? You might be adding hours to your script's runtime without even knowing it. I see this all the time: analysts use loops for data transformations that could be done in a fraction of the time. The bottleneck isn't your computer's speed—it's how you're talking to it. The secret to faster data processing in Python is vectorization. Instead of processing each element one-by-one in a loop, vectorized operations apply a function to an entire dataset simultaneously, leveraging optimized, pre-compiled C code under the hood. Let's take a common task: calculating the square of every number in a list. The Slow Way (Loop): python import pandas as pd data = pd.Series(range(1, 1000001)) squared_list = [] for num in data: squared_list.append(num ** 2) The Fast Way (Vectorized): python import pandas as pd data = pd.Series(range(1, 1000001)) squared_list = data ** 2 The vectorized approach isn't just cleaner—it's dramatically faster. For a million rows, the loop might take ~150ms, while the vectorized operation can finish in ~2ms. That's a 98.7% reduction in processing time! This principle applies across pandas and NumPy: Use df['column'].str.upper() instead of looping with .upper() Use df['column'].apply(function) instead of a for-loop (.apply is optimized) Use NumPy's universal functions (np.log, np.sqrt) on arrays Adopting a vectorized mindset is a game-changer for efficiency. Have you ever refactored a slow loop into a vectorized operation? What was the performance boost like? Share your story below! #Python #DataAnalysis #Pandas #CodingTips #DataScience

🚀 Just built my own Python data type using OOP & magic methods! We all know Python gives us built-in types like int, float, and list... But what if we could design our own — that behaves just like them? 🤯 That’s exactly what I did with PyMatrixEngine 🧠 I built a custom Matrix data type that supports operations such as: ➕ Addition (A + B) ➖ Subtraction (A - B) ✖️ Multiplication (A * B) 🔁 Transpose & Determinant All powered by Python’s magic methods (__add__, __mul__, __str__, and friends) 🪄 And here’s the cool part — If you input something that doesn’t form a valid matrix, this datatype automatically checks it and raises a clean, readable error. No more silent shape mismatches or confusing bugs ✅ You can simply drop the file in your project and start using it: from matrix import Matrix A = Matrix([[1,2],[3,4]]) B = Matrix([[5,6],[7,8]]) print(A + B) print(A * B) print(A.determinant()) It’s a fun deep-dive into Object-Oriented Programming (OOP) and Python’s hidden superpowers: magic methods ✨ 🧩 GitHub Repo → https://lnkd.in/gkrheMQS Would love to hear — what’s the coolest custom data type you’ve ever built in Python? #Python #OOP #MagicMethods #Coding #Matrix #Learning #PythonProjects #Developers #PythonTips

#Day65 of #100DaysOfPython : Reading PDF Data in Python In the world of data, PDFs are everywhere-from reports and invoices to research papers. But extracting insights from PDFs programmatically can be tricky due to their varied formatting. Luckily, Python offers powerful libraries to help you read and work with PDF files efficiently. ⚒️ How to Read PDF Data in Python? 1️⃣ Using PyPDF2 (for basic text extraction): PyPDF2 is a popular library for reading and extracting text from PDF pages. It allows you to open PDF files, read specific pages, and extract the text content. Example snippet: import PyPDF2 with open('sample.pdf', 'rb') as file: reader = PyPDF2.PdfReader(file) text = '' for page in reader.pages: text += page.extract_text() print(text) 2️⃣ Using pdfplumber (for more complex layouts): pdfplumber offers more advanced PDF parsing, handling tables, columns, and layouts more accurately. It's excellent when you need reliable extraction from structured PDFs. 3️⃣ Using fitz (PyMuPDF) (for high performance and flexibility): PyMuPDF lets you extract text, images, metadata, and even manipulate PDFs comprehensively. It’s a great all-rounder for PDF processing. ❓ Why Reading PDFs Programmatically Matters? ✅ Automate data extraction from reports, invoices, contracts, research papers. ✅ Save hours of manual copy-pasting work. ✅ Enable deeper data analysis on document content. As Python developers or data enthusiasts, mastering PDF reading is a valuable skill with wide business and research applications. What’s your go-to Python library for PDFs? Share your tips or ask if you want sample code! #Python #100DaysOfPython #100DaysOfCode #PythonProgramming #PythonTips #DataScience #MachineLearning #ArtificialIntelligence #DataEngineering #Analytics #PythonForData #AI #CommunityLearning #Coding #LearnPython #Programming #SoftwareEngineering #CodingJourney #Developers #CodingCommunity

This is the only Python for Data Analysis cheat sheet you'll ever need! If you're working in Data Science, mastering Python—especially NumPy and Pandas—is non-negotiable. When I started learning, I often found myself lost in documentation or googling function names every 10 minutes. That’s why I created this one-stop Python Cheat Sheet to simplify your learning and supercharge your projects. From array operations to DataFrame manipulations, it’s got everything you need: ➡️ Build a strong foundation with NumPy ➡️ Slice, reshape, and aggregate data like a pro ➡️ Handle missing values, group data, and perform joins with Pandas ➡️ Analyze trends using rolling, expanding, and window functions 💡 Pro Tip: The best way to master Python for data analysis is by doing. Try real-world datasets, replicate case studies, and keep this sheet handy. Whether you're preparing for interviews or building dashboards, this cheat sheet has your back. 🚨 Remember: Python isn’t just a language. It’s your superpower. 🧠⚡ Found it helpful ? ♻️ Repost

🐍 The Only Python for Data Analysis Cheat Sheet You’ll Ever Need! 📊🔥 If you’re into Data Science, mastering Python (NumPy + Pandas) is non-negotiable. When I started out, I used to get lost in documentation and Google every 10 minutes. 😅 That’s why I created a one-stop Python Cheat Sheet — to simplify learning and supercharge your data projects 🚀 Here’s what you’ll get 👇 ✅ Build a strong foundation with NumPy ✅ Slice, reshape & aggregate data like a pro ✅ Handle missing values, group data & perform joins with Pandas ✅ Analyze trends using rolling, expanding, and window functions 💡 Pro Tip: The fastest way to master Python for data analysis is hands-on learning. Work with real datasets, replicate case studies, and keep this sheet handy. Whether you’re prepping for interviews or building dashboards, this cheat sheet has your back. 🙌 ⚡ Remember: Python isn’t just a language — it’s your Data Superpower. 🧠💥 📥 Want me to share the downloadable cheat sheet PDF? Comment “PYTHON” below ⬇️ and I’ll send it to you! #Python #DataScience #Pandas #NumPy #MachineLearning #DataAnalytics #DataEngineer #BigData #PythonTips #DataAnalysis #LearningPython #Analytics #AI #DataVisualization #CareerGrowth #TechCommunity #pythoncheatsheet

File Handling in Python: Saving Your Coffee Recipes 📁☕ Imagine creating the perfect coffee recipe today… but tomorrow you forget the steps! 😅 Wouldn’t it be great if you could save your recipes for later? That’s exactly what file handling does in Python - it helps you store and retrieve information whenever you want. 💾 🗂️ Reading & Writing Files In Python, you can easily create, write, and read files using the open() function. ✍️ Writing to a File file = open("recipes.txt", "w") # 'w' means write file.write("Latte = Coffee + Milk + Sugar\n") file.write("Espresso = Strong Coffee ☕\n") file.close() print("Recipes saved!") ✅ This creates a file called recipes.txt and writes inside it. 📖 Reading from a File file = open("recipes.txt", "r") # 'r' means read content = file.read() file.close() print("Your saved recipes:\n", content) ✅ Output: Your saved recipes: Latte = Coffee + Milk + Sugar Espresso = Strong Coffee ☕ 🔄 Modes in File Handling ->r - Read filew ->w - Write (overwrites old data) ->a - Append (adds new data) ->r+ - Read & write 🧠 Why It’s Important Saves data permanently Used in data analysis, web apps, and AI logs Helps automate real-world tasks Think of it as your digital recipe book - Python helps you write, store, and reuse your ideas anytime! 💡 💬 Try this today: Write a program that saves your favorite drink to a file and prints it back. #PythonWithKeshav #LearnPython #PythonBasics #FileHandling #CodingJourney #ProgrammingForBeginners #PythonForAll #Automation #STEMEducation #PythonLearning