CSV Explorer

Explore a CSV file in Python

The same first look in plain pandas, to use on your own files.

import pandas as pd
from io import StringIO

csv_text = """name,city,marks
Asha,Chennai,91
Ben,Mumbai,
Chen,Chennai,78
"""
df = pd.read_csv(StringIO(csv_text))   # pd.read_csv("file.csv") for a real file

print(df.shape)            # rows, columns
print(df.dtypes)           # the type pandas chose for each column
print(df.isna().sum())     # missing values per column
print(df["marks"].mean())  # missing values are skipped
print(df["city"].value_counts())

Go further with pandas for beginners, cleaning data and Python's csv module.

Questions