Introduction to Pandas: The SQL of Python

What is Pandas?

Pandas is a Python library that lets you work with data in a tabular format—rows and columns, just like SQL.

The DataFrame

A DataFrame is like a SQL table.

import pandas as pd

data = {

'name': ['Alice', 'Bob', 'Charlie'],

'age': [25, 30, 35],

'city': ['NYC', 'LA', 'Chicago']

}

df = pd.DataFrame(data)

print(df)

SQL Translation

| SQL | Pandas |

|-----|--------|

| `SELECT *` | `df` |

| `SELECT name, age` | `df[['name', 'age']]` |

| `WHERE age > 25` | `df[df['age'] > 25]` |

| `ORDER BY age` | `df.sort_values('age')` |

*Day 104: Reading Data from CSVs and Databases.*