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

Jul 8, 2023#python学习67

AI Translation

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

AI-generated summary

Today, the person learned how to manipulate CSV files. They learned a new way to open files using "with open(file) as f", which is more convenient than using "f=open(file)" because it doesn't require using "f.close()". They also learned about the string concatenation function "str.join('symbol', str)" to join elements in a string using a symbol. They learned about the csv function "csv.DictReader()" to parse CSV content into a dictionary format, where the table headers are keys and each column is a data item. They imported the csv module at the beginning of their code. They practiced by writing a small program to calculate income by reading data from a CSV file. The program calculates the total income and prints it.

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 is to write a small program that calculates 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.")

Translation: