From the course: Advanced Hands-On Python: Working with Excel and Spreadsheet Data
Join today to access over 24,600 courses taught by industry experts.
Writing a CSV file
From the course: Advanced Hands-On Python: Working with Excel and Spreadsheet Data
Writing a CSV file
- [Instructor] Being able to read CSV files is only half the equation. We need to be able to write CSV data as well. The CSV module provides a set of classes and functions for doing exactly that. So in this example, we're going to see how to write data that is in an array format, and we'll see how to write dictionary data in a separate video. So for this example, let's open up write_csv_array.py. And for this example, you can see that I've already got some code that defines an array of rows of data. The first row is the header information, and the rest of the rows contain lists of different food types and prices. It's essentially a subset of the inventory file that we've been working with in the chapter. So let's write a function that will write the data to a CSV file. So let's declare the function, and we'll call it write_array_to_csv. And that will take in the data to write along with a filename. Then all we need to do is open the file that we want to write to. So I'll use my with…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
The CSV format1m 20s
-
Reading CSV files into an array4m 22s
-
(Locked)
Reading CSV files into a dictionary7m 14s
-
(Locked)
Reading CSV files with a filter2m 54s
-
(Locked)
Writing a CSV file2m 34s
-
(Locked)
Writing a dictionary as CSV4m 8s
-
(Locked)
Challenge: Modify CSV content2m 3s
-
(Locked)
Solution: Modify CSV content2m 59s
-
-
-
-
-