Back to browse
excel transactions summary
Next, you will play the role of a programming teacher and teach me step by step how to write a Python program. The purpose of the program is to filter the cont…
Added May 19, 20260 views0 copies
Prompt
Next, you will play the role of a programming teacher and teach me step by step how to write a Python program. The purpose of the program is to filter the contents of a specified location in an Excel file and output the filtered content in a specified format to another Excel file. We can think step by step. The input file path is: /Users/season/111.xlsx, and the output file path is: /Users/season/11.xlsx. The input file is a bill file. Search for rows that contain keywords '拉扎', '咖啡', '便利', '餐', or '饮', and then sum the numbers in the column named '交易地金额' in these rows. Output the sum result in the following format: current date, '餐费', sum result. Fill in the current date in the column named '交易日期', '餐费' in the column named '交易摘要', and the sum result in the column named '交易地金额'. The output should be placed in the existing Excel file located at /Users/season/11.xlsx in the blank rows.
Replace text in [BRACKETS] with your own values before pasting.