Operate csv - 54 days - Learn Python online for 100 days.

Jul 8, 2023#python学习49

AI Translation

This post is translated from Chinese into English through AI.View Original

AI-generated summary

Today's lesson focused on working with CSV files. The "with open(file) as f" method was introduced as a more convenient way to open files compared to the traditional "f=open(file)" method. The "str.join()" function was discussed as a way to concatenate strings using a specified symbol. The "csv.DictReader()" function was explained as a way to parse CSV content into a dictionary format, with the table headers serving as keys. The exercise involved creating a program to calculate income by reading data from a CSV file. The code used the "csv" module to read the file and calculate the total income for the day. The program then printed the result.

Record#

Today, I learned how to manipulate CSV files.
"with open(file) as f" is a new way to open files. It is more convenient compared to "f=open(file)" because it does not require using "f.close()".
The string concatenation function is "str.join('symbol', str)". It joins the elements in the string using the specified symbol.
The CSV function is "csv.DictReader()". It parses the CSV content into a dictionary format, although it is not exactly the same as a real dictionary. The CSV header serves as the key, and the corresponding column is a data item.
When working with CSV files, it is necessary to import the csv module at the beginning of the file.
Today's exercise involves writing a small program to calculate income. It reads data from a CSV file and performs calculations.

CODE#

import csv
total = 0.0
daytotal = 0.0
with open("Day54Totals.csv", "r") as file:
  reader = csv.DictReader(file)
  for row in reader:
    total = float(row['Cost']) * float(row['Quantity'])
    daytotal += total
print("🌟Shop $$ Tracker🌟")
print(f"Your shop took £{round(daytotal, 2)} pounds today.")