Skip to main content
Brave Programmer Logo

BraveProgrammer

BraveProgrammer

HomeProjectsBlogsCoursesLessonsAbout

Site footer

BraveProgrammer

Free coding courses, practical tutorials, and real projects from BraveProgrammer. Learn web development with React, Next.js, and TypeScript.

Navigation

  • Home
  • Projects
  • Blogs
  • Courses

Resources

  • About
  • Lessons
  • Teach on BraveProgrammer

© 2026 BraveProgrammer. All rights reserved.

Reading Data: CSV, E | Master Data Science with Python lesso | BraveProgrammer
  1. Courses
  2. /
  3. Master Data Science with Python

Lesson 19 of 60

·python

Reading Data: CSV, Excel, JSON, and More

20 minutes

Course progress32%

Reading Data into Pandas

In practice, data lives in files, databases, or APIs. Pandas can ingest many formats.

CSV files

df_csv = pd.read_csv('data/sales.csv')
print(df_csv.head())

Excel files

df_excel = pd.read_excel('data/financials.xlsx', sheet_name='2023')
(df_excel.shape)
print

JSON files

import json
with open('data/users.json') as f:
    data = json.load(f)

df_json = pd.json_normalize(data)
print(df_json.head())

Reading from a URL

titanic_url = "https://raw.githubusercontent.com/datasciencedojo/datasets/master/titanic.csv"
df_titanic = pd.read_csv(titanic_url)
print(df_titanic.shape)

Parameters to control parsing

  • sep: column delimiter
  • parse_dates: column(s) to parse as datetime
  • usecols: subset of columns to read
  • dtype: enforce column types
df = pd.read_csv('data/sample.csv', sep=';', parse_dates=['date'], dtype={'id': int})

Info

Large CSVs can be loaded in chunks with chunksize to avoid memory overflow.
Make it stickPractice what you've learned1 quiz · 4 practical tests · Optional activities from Master Data Science with PythonBrowse activities
Previous lessonDataFrames: Tabular Data in PandasContinue to lesson 20Writing Data: Exporting DataFramesBack to Master Data Science with Python curriculum