Pandas DataFrame Analysis
View and analyze your data frames with built-in Pandas methods. Stats made simple!
Example 1: Get a quick statistical summary.
df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})
print(df.describe())
Example 2: Calculate column-wise means.
df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})
print(df.mean())
Example 3: Return the first n rows in a data frame.
data = {
"Name": ["John", "Alice", "Bob", "Emma", "Mike"],
"Age": [25, 30, 35, 28, 32],
"City": ["New York", "Paris", "London", "Sydney", "Tokyo"],
}
df = pd.DataFrame(data)
print(df.head(3))
Example 4: Return the last n rows in a data frame.
data = {
"Name": ["John", "Alice", "Bob", "Emma", "Mike"],
"Age": [25, 30, 35, 28, 32],
"City": ["New York", "Paris", "London", "Sydney", "Tokyo"],
}
df = pd.DataFrame(data)
print(df.tail(3))
Example 5: Get the data frame information.
data = {
"Name": ["John", "Alice", "Bob", "Emma", "Mike"],
"Age": [25, 30, 35, 28, 32],
"City": ["New York", "Paris", "London", "Sydney", "Tokyo"],
}
df = pd.DataFrame(data)
print(df.info())
đź’ˇ
Pro tip: Let Pandas do the math while you grab a coffee.
Pandas DataFrame Manipulation
Add, update, or drop columns and rows with ease.
Example 1: Add and drop columns.
data = {
"Name": ["John", "Alice", "Bob", "Emma", "Mike"],
"Age": [25, 30, 35, 28, 32],
"City": ["New York", "Paris", "London", "Sydney", "Tokyo"],
}
df = pd.DataFrame(data)
df["Country"] = ["United States", "France", "United Kingdom", "Australia", "Japan"]
print(df.head(2))
print("================")
df.drop("Age", axis=1, inplace=True)
print(df.head(2))
Example 2: Insert and drop rows.
data = {
"Name": ["John", "Alice", "Bob", "Emma", "Mike"],
"Age": [25, 30, 35, 28, 32],
"City": ["New York", "Paris", "London", "Sydney", "Tokyo"],
}
df = pd.DataFrame(data)
df.loc[len(df.index)] = ["Drake", 32, "Bangkok"]
print(df.tail(2))
print("================")
df.drop(1, axis=0, inplace=True)
print(df.head(2))
Example 3: Rename column names and indexes.
data = {
"Name": ["John", "Alice", "Bob", "Emma", "Mike"],
"Age": [25, 30, 35, 28, 32],
"City": ["New York", "Paris", "London", "Sydney", "Tokyo"],
}
df = pd.DataFrame(data)
df.rename(columns={"City": "Address"}, inplace=True)
print(df.head(2))
print("================")
df.rename(index={1: 100}, inplace=True)
print(df.head(2))
Think of it like playing Tetris but with data.
Pandas Indexing and Slicing
Access data with labels or positions—no guessing required.
Example 1: Indexing by column or row.
df = pd.DataFrame({'A': [10, 20], 'B': [30, 40]})
print(df['A'])
print(df.iloc[0])
print(df.loc[0])
Example 2: Slice rows and columns.
print(df.iloc[:1])
print(df[['A', 'B']])
Indexing in Pandas is like peeling an onion: layer by layer.
Pandas Select
Filter specific rows or data based on conditions.
Example 1: Simple condition.
print(df[df['A'] > 15])
Example 2: Multiple conditions.
print(df[(df['A'] > 10) & (df['B'] < 40)])
It’s like swiping right on the rows you love.
Pandas Multiindex
For when a single index just isn’t enough.
Example: Create and use a MultiIndex.
arrays = [['A', 'A', 'B'], [1, 2, 1]]
index = pd.MultiIndex.from_arrays(arrays, names=('Letter', 'Number'))
df = pd.DataFrame({'Value': [10, 20, 30]}, index=index)
print(df)
MultiIndex is for the overachievers. You know who you are.
Pandas Reshape
Reshape your data with melt and pivot.
Example 1: Use melt for long format.
df = pd.DataFrame({'ID': [1, 2], 'Value': [10, 20]})
melted = pd.melt(df, id_vars='ID')
print(melted
Example 2: Use pivot for wide format.
pivoted = melted.pivot(index='ID', columns='variable', values='value')
print(pivoted)
Shape your data like a pro.
Pandas Duplicate Values
Find and remove duplicate rows. Because no one likes redundancy.
Example 1: Detect duplicates.
df = pd.DataFrame({'A': [1, 1, 2], 'B': [3, 3, 4]})
print(df.duplicated())
Example 2: Drop duplicates.
df.drop_duplicates(inplace=True)
print(df
Duplicates, begone!
Pandas Pivot
Reorganize your data with pivot.
Example: Pivot data.
data = {'Date': ['2024-01-01', '2024-01-02'], 'Value': [10, 20]}
df = pd.DataFrame(data)
pivoted = df.pivot(index='Date', columns='Value')
print(pivoted)
Pivots make data feel fancy.
Pandas Pivot Table
Summarize data with a pivot table.
Example: Create a pivot table.
data = {'Category': ['A', 'A', 'B'], 'Value': [10, 20, 30]}
df = pd.DataFrame(data)
pivot_table = df.pivot_table(values='Value', index='Category', aggfunc='sum')
print(pivot_table)
You’re basically at Excel-level now.
