Pandas — DataFrames

Create DataFrame

import pandas as pd

# From dictionary
df = pd.DataFrame({
    'name': ['Alice', 'Bob', 'Charlie'],
    'age': [25, 30, 35],
    'city': ['NYC', 'LA', 'Chicago']
})

# From list of lists
df = pd.DataFrame([['Alice', 25], ['Bob', 30]], columns=['name', 'age'])

Basic info

print(df.head())      # First 5 rows
print(df.shape)       # (rows, cols)
print(df.columns)     # Column names
print(df.dtypes)      # Data types
print(df.info())      # Summary
print(df.describe())  # Statistics

Selection

# Select column
df['name']

# Select multiple columns
df[['name', 'age']]

# Select row by label
df.loc[0]

# Select row by position
df.iloc[0]

Mini Practice

1. Create DataFrame
2. View basic info
3. Select columns
4. Use loc and iloc

Up Next

Continue with CSV - Reading/writing CSV files.