Logging to CSV files in Raspberry Pi - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a CSV file and why is it useful for logging?

A CSV (Comma-Separated Values) file stores data in plain text with values separated by commas. It is useful for logging because it is simple, easy to read, and can be opened by many programs like spreadsheets.

beginner

How do you write a new line of data to a CSV file in Python on a Raspberry Pi?

You open the file in append mode ('a'), then write a line with values separated by commas, ending with a newline character. For example: with open('log.csv', 'a') as f: f.write('value1,value2,value3\n')

beginner

Why should you open a CSV file in append mode when logging data continuously?

Append mode ('a') adds new data at the end of the file without deleting existing data. This keeps all previous logs intact while adding new entries.

intermediate

What Python module can help handle CSV files more safely and easily?

The 'csv' module in Python provides functions to read and write CSV files properly, handling commas inside data and quoting automatically.

intermediate

How can you include a timestamp in each log entry in a CSV file?

You can get the current time using Python's datetime module, then add it as a value in your CSV line. For example: from datetime import datetime; now = datetime.now().isoformat()

What file mode should you use to add new log entries to a CSV file without erasing old data?

A Append mode ('a')

B Write mode ('w')

C Read mode ('r')

D Exclusive creation mode ('x')

Append mode ('a') adds new data at the end of the file without deleting existing content.

Which Python module helps you write CSV files correctly, handling commas inside data?

A os

B json

C sys

D csv

The 'csv' module is designed to read and write CSV files properly.

What character usually separates values in a CSV file?

A Comma (,)

B Tab (\t)

C Space ( )

D Semicolon (;)

CSV stands for Comma-Separated Values, so commas separate the values.

How can you add the current date and time to each log entry in Python?

A Use the time.sleep() function

B Use datetime.now() from the datetime module

C Use print() function

D Use os.system()

datetime.now() gives the current date and time, which you can add to your log.

Why is logging to a CSV file helpful on a Raspberry Pi?

A Because CSV files are encrypted

B Because CSV files are binary and fast

C Because CSV files can be opened easily and are human-readable

D Because CSV files automatically upload to the cloud

CSV files are simple text files that can be opened by many programs and are easy to read.

Explain how to log sensor data to a CSV file on a Raspberry Pi using Python.

Think about how to add new lines without deleting old data and how to format the data.

Describe the benefits of using the Python csv module instead of writing CSV lines manually.

Consider what problems might happen if you write CSV lines as plain text.

Practice

1. What is the main reason to log data to a CSV file on a Raspberry Pi?

easy

A. To prevent the Raspberry Pi from overheating

B. To make the Raspberry Pi run faster

C. To install new software automatically

D. To store data in a simple table format that is easy to read and analyze

Solution

1. Step 1: Understand the purpose of CSV logging

   CSV files store data in rows and columns, making it easy to read and analyze later.

2. Step 2: Identify the benefit for Raspberry Pi logging

   Logging data in CSV helps keep records in a simple format without complex software.

3. Final Answer:

   To store data in a simple table format that is easy to read and analyze -> Option D

4. Quick Check:

   CSV logging = simple readable data [OK]

Hint: CSV files keep data organized in rows and columns [OK]

Common Mistakes:

• Thinking CSV speeds up the Raspberry Pi
• Confusing CSV logging with hardware functions
• Assuming CSV files install software

2. Which Python code snippet correctly opens a CSV file for appending new log entries on a Raspberry Pi?

easy

A. open('log.csv', 'r')

B. open('log.csv', 'w')

C. open('log.csv', 'a')

D. open('log.csv', 'x')

Solution

1. Step 1: Understand file modes in Python

   'r' is read-only, 'w' overwrites, 'a' appends, 'x' creates new file only if not exists.

2. Step 2: Choose mode to add logs without erasing old data

   Appending mode 'a' adds new lines at the end without deleting existing logs.

3. Final Answer:

   open('log.csv', 'a') -> Option C

4. Quick Check:

   Append mode = 'a' [OK]

Hint: Use 'a' mode to add data without erasing old logs [OK]

Common Mistakes:

• Using 'w' which erases existing file content
• Using 'r' which does not allow writing
• Using 'x' which fails if file exists

3. What will be the output in the CSV file after running this Python code on Raspberry Pi?

import csv
with open('log.csv', 'a', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(['Time', 'Temperature'])
    writer.writerow(['10:00', '22'])

medium

A. A CSV file with two rows: header and one data row

B. An empty CSV file

C. A CSV file with only one row containing 'Time, Temperature, 10:00, 22'

D. A syntax error occurs

Solution

1. Step 1: Analyze the code writing rows to CSV

   The code writes two rows: first is header ['Time', 'Temperature'], second is data ['10:00', '22'].

2. Step 2: Understand CSV file content after appending

   Both rows are added as separate lines in the CSV file.

3. Final Answer:

   A CSV file with two rows: header and one data row -> Option A

4. Quick Check:

   Two rows written = header + data [OK]

Hint: Each writer.writerow adds one row to CSV [OK]

Common Mistakes:

• Thinking data merges into one row
• Expecting syntax errors from correct code
• Assuming file stays empty after writing

4. You run this code on your Raspberry Pi but the CSV file remains empty:

import csv
file = open('log.csv', 'w')
writer = csv.writer(file)
writer.writerow(['Date', 'Value'])
file.close()

What is the likely problem?

medium

A. The file was not closed properly

B. The newline parameter is missing in open() causing blank lines

C. The file was not opened in append mode

D. The writerow method was not called correctly

Solution

1. Step 1: Check file opening and writing

   File is opened in write mode and writerow is called correctly.

2. Step 2: Identify missing newline='' causing blank lines on Windows/Linux

   Without newline='', csv.writer may write extra blank lines or cause issues making file appear empty.

3. Final Answer:

   The newline parameter is missing in open() causing blank lines -> Option B

4. Quick Check:

   Use newline='' to avoid blank lines in CSV [OK]

Hint: Always use newline='' when opening CSV files for writing [OK]

Common Mistakes:

• Assuming append mode is required to write
• Forgetting to close the file (but here it is closed)
• Thinking writerow syntax is wrong

5. You want to log sensor data every minute on your Raspberry Pi into a CSV file without losing old data. Which Python code snippet correctly achieves this?

hard

A. import csv
with open('sensor_log.csv', 'a', newline='') as f:
writer = csv.writer(f)
writer.writerow(['12:01', '32'])

B. import csv
with open('sensor_log.csv', 'x', newline='') as f:
writer = csv.writer(f)
writer.writerow(['12:03', '33'])

C. import csv
with open('sensor_log.csv', 'r') as f:
writer = csv.writer(f)
writer.writerow(['12:02', '31'])

D. import csv
with open('sensor_log.csv', 'w', newline='') as f:
writer = csv.writer(f)
writer.writerow(['Time', 'Value'])
writer.writerow(['12:00', '30'])

Solution

1. Step 1: Identify file mode to keep old data

   Mode 'a' appends new data without erasing existing logs, perfect for ongoing logging.

2. Step 2: Check code correctness for logging new data

   Code opens file in append mode with newline='', writes one new row with time and value.

3. Final Answer:

   Code that appends new rows without deleting old data -> Option A

4. Quick Check:

   Append mode + newline='' = safe logging [OK]

Hint: Use 'a' mode and newline='' to add logs safely [OK]

Common Mistakes:

• Using 'w' mode which erases old logs
• Using 'r' mode which is read-only
• Using 'x' mode which fails if file exists