Selecting and Filtering Data in Pandas

Select Columns

df['name'] # Single column (Series)

df[['name', 'age']] # Multiple columns (DataFrame)

Filter Rows (WHERE)

df[df['age'] > 25] # Simple filter

df[(df['age'] > 25) & (df['city'] == 'NYC')] # AND logic

df[(df['age'] > 25) | (df['city'] == 'LA')] # OR logic

.loc and .iloc

df.loc[0, 'name'] # By label (row 0, column 'name')

df.iloc[0, 1] # By integer position (row 0, column 1)

*Day 106: Sorting and Limiting Data.*