pandas for Python for Data Analysiss
pandas is the Python library that gives you the DataFrame, a labelled table of columns with mixed types, plus tools to read files and clean them. In an analysis workflow it sits after NumPy and holds the data while you fix types, missing values, duplicates and inconsistent text.
Stage: Tools · Part of the Python for Data Analysis roadmap · Last reviewed 19 November 2026
What to learn in pandas
- Load a CSV or Excel file into a DataFrame with read_csv
- Select rows and columns using loc, iloc and boolean conditions
- Handle missing values with isna, fillna and dropna and justify the choice
- Convert column dtypes, including dates and categories
- Remove duplicates and standardise messy text with the str accessor
- Merge two DataFrames on a key and check the row count
pandas interview questions
What is the difference between loc and iloc in pandas?
loc selects by label, so the row index values and column names, and its slices include the end label. iloc selects by integer position, like a list, and its slices exclude the end. Mixing them up is a common source of off-by-one bugs.
How do you deal with missing values in a DataFrame?
First measure them with isna().sum() and ask why they are missing. Then drop rows if few are affected, fill with a constant, median or group-wise value, or keep them as a flag. The choice depends on the column and the analysis goal.
Where pandas fits in the Python for Data Analysis roadmap
pandas belongs to the Tools stage (beginner level), which takes about 27 hours. Python for data.
Other units in this stage
Back to the full Python for Data Analysis roadmap