1.0Portfolio Oscar Javier Munoz Marcialeshttps://artechsano.prooscarxxihttps://artechsano.pro/author/oscarxxi/rich600338<blockquote class="wp-embedded-content" data-secret="UhXVmBhOmZ"><a href="https://artechsano.pro/articles/getting-started-with-pandas-a-beginners-guide/">Getting Started with Pandas: A Beginner’s Guide</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://artechsano.pro/articles/getting-started-with-pandas-a-beginners-guide/embed/#?secret=UhXVmBhOmZ" width="600" height="338" title="“Getting Started with Pandas: A Beginner’s Guide” — Portfolio Oscar Javier Munoz Marciales" data-secret="UhXVmBhOmZ" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript"> /* <![CDATA[ */ /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://artechsano.pro/wp-includes/js/wp-embed.min.js /* ]]> */ </script> https://artechsano.pro/wp-content/uploads/2025/11/Gemini_Generated_Image_vo2mchvo2mchvo2m.png10241024If you’re new to Python and curious about data analysis, you’ve probably heard of Pandas. This powerful library is an essential tool for anyone working with data—from spreadsheets to databases to web-scraped information. It’s the foundation for most data science workflows in Python. In this post, we’ll explore what Pandas is, why it’s so useful, and walk through the core operations you need to start analyzing data today. 📦 What Is Pandas? Pandas is an open-source Python library built for data manipulation and analysis. It provides high-performance, easy-to-use data structures that make working with “relational” or “labeled” data (like you’d find in a spreadsheet) simple and intuitive. It introduces two primary data structures: Series: A one-dimensional labeled array. Think of it as a single column in a spreadsheet, like a list of ages, but with custom labels (called an index). DataFrame: A two-dimensional labeled data structure with columns of potentially different types. This is the workhorse of Pandas. It’s the whole spreadsheet—a collection of Series (columns) that share the same index (rows). You can easily create them from scratch to experiment: 🐍 filename.py import pandas as pd # A Series (one column) s = pd.Series([10, 20, 30], index=['a', 'b', 'c']) # A DataFrame (multiple columns) data = {'Product': ['Apples', 'Oranges', 'Bananas'], 'Price': [0.5, 0.4, 0.25]} df = pd.DataFrame(data) 🚀 Why Use Pandas?   Here’s why Pandas is a favorite among data analysts, scientists, and Python developers: Simple & Intuitive: The syntax is designed to be readable and expressive, letting you accomplish complex tasks in just a few lines. Flexible Data Handling: It can read and write data from a huge variety of formats, including CSV, Excel, JSON, SQL databases, HTML, and more. Powerful Operations: It makes complex operations simple. You can effortlessly filter, group, merge, pivot, and reshape data. It also has specialized, powerful tools for working with time series data. Performance: It’s built on top of NumPy, which means many of its operations are vectorized and optimized for speed. Integration: It plays perfectly with other libraries in the scientific Python ecosystem, like NumPy (for computation), Matplotlib/Seaborn (for plotting), and Scikit-learn (for machine learning).   🛠️ Getting Started: Installation & Loading Data   To begin, you’ll need to install Pandas. The most common way is with pip: 🐍 pip install pandas Once installed, you import it into your Python script (the as pd is a standard, widely-used alias): 🐍 import pandas as pd While you can create DataFrames from scratch (as shown above), you’ll usually load data from a file. Let’s load a simple CSV file: 🐍 # Reads a CSV file into a DataFrame df = pd.read_csv('your_data.csv') # You can also easily read from other file types # df_excel = pd.read_excel('your_data.xlsx') 🔍 Exploring Your Data: The Basic Workflow   Once your data is loaded into a DataFrame, the first step is always inspection. You need to understand what you’re working with. Let’s assume we loaded a df. Here are the most critical commands:   1. Inspecting Your Data   See the first few rows: df.head() (by default, it shows 5). See the last few rows: df.tail() Get a concise summary: df.info() This is crucial! It shows row/column counts, column names, data types (e.g., int64, float64, object), and, most importantly, the number of non-null (non-empty) values. Get quick statistics: df.describe() For numerical columns, this shows count, mean, standard deviation, min, max, and percentiles. See the dimensions: df.shape (returns a tuple: (rows, columns)) See the column names: df.columns   2. Selecting & Filtering Data   This is where you’ll spend a lot of your time. Select a single column (returns a Series): df['column_name'] Select multiple columns (returns a new DataFrame): df[['col1', 'col2']] Select rows by position (integer-based): df.iloc[0] (gets the very first row) df.iloc[0:5] (gets the first five rows) Select rows by label/index (label-based): df.loc['index_label'] (if your index is a name, e.g., ‘a’, ‘b’, ‘c’) Conditional Filtering (Boolean Masking): This is the most powerful way to select data. df[df['age'] > 30] (selects all rows where the ‘age’ column is over 30) df[(df['age'] > 30) & (df['city'] == 'New York')] (use & for “and”, | for “or”)   3. Manipulating & Cleaning Data   Create a new column: df['new_column'] = df['col1'] + df['col2'] Handle missing data: df.dropna() (drops all rows with any missing values) df.fillna(value=0) (fills all missing values with 0) Rename columns: df = df.rename(columns={'old_name': 'new_name', 'another_old': 'another_new'})   4. Aggregating & Grouping Data   This is the key to summarizing your data. The “split-apply-combine” pattern is famous for a reason. The groupby method: df.groupby('category').mean() (calculates the mean of all numeric columns for each unique category) Let’s look at the simple example from your original post. Imagine you have sales data: 🐍 # 1. Create a new 'revenue' column df['revenue'] = df['price'] * df['quantity'] # 2. Group by product and sum the revenue revenue_by_product = df.groupby('product')['revenue'].sum() print(revenue_by_product) You can also get multiple statistics at once using .agg(): 🐍 # Get total revenue and average price per product stats = df.groupby('product').agg({ 'revenue': 'sum', 'price': 'mean' }) print(stats) 5. Combining DataFrames   Merging (like a SQL JOIN): Combines DataFrames based on a common column. pd.merge(df1, df2, on='id_column') Concatenating (stacking): Stacks DataFrames on top of each other (if they have the same columns). pd.concat([df1, df2])   📈 Bonus: Quick Visualization   One of the best features of Pandas is its built-in plotting, which uses Matplotlib under the hood. This lets you get a quick visual check of your data without importing another library. After our groupby example above, you could instantly plot the results: 🐍 # Assuming 'revenue_by_product' is the Series from the last example revenue_by_product.plot(kind='bar', title='Total Revenue by Product') Or, you could plot a histogram of a single column from your original DataFrame: 🐍 df['price'].plot(kind='hist', bins=20, title='Price Distribution') 📚 Learning Resources   Ready to go deeper? These resources are fantastic for leveling up your Pandas skills: Official Pandas Documentation: The user guide and API reference are essential. Kaggle Learn: They have an excellent, free, hands-on micro-course on Pandas. Real Python: Features numerous