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.

Writing Data: Export | Master Data Science with Python lesso | BraveProgrammer
  1. Courses
  2. /
  3. Master Data Science with Python

Lesson 20 of 60

·python

Writing Data: Exporting DataFrames

15 minutes

Course progress33%

Exporting DataFrames

After processing, you often need to save results.

To CSV

df.to_csv('output/cleaned.csv', index=False)

To Excel

df.to_excel('output/report.xlsx', sheet_name='Summary', index=False)

To JSON

df.to_json('output/data.json', orient='records', lines=True)

To SQL (using SQLAlchemy)

from sqlalchemy import create_engine
engine = create_engine('sqlite:///mydb.sqlite')
# Write DataFrame to a table called "sales"
df.to_sql('sales', con=engine, if_exists='replace', index=False)

Compression

df.to_csv('output/compressed.csv.gz', compression='gzip')

Info

When sharing data, consider to_parquet for columnar storage and faster I/O.
df.to_parquet('output/data.parquet')
```</Alert>
Make it stickPractice what you've learned1 quiz · 4 practical tests · Optional activities from Master Data Science with PythonBrowse activities
Previous lessonReading Data: CSV, Excel, JSON, and MoreContinue to lesson 21Selecting & Filtering Data in PandasBack to Master Data Science with Python curriculum