python将csv的每一行求和,需要在Python中的几个CSV文件中的每一行上进行数学运算...

最新推荐文章于 2023-04-14 14:59:31 发布

华语演讲网

最新推荐文章于 2023-04-14 14:59:31 发布

阅读量717

点赞数

文章标签： python将csv的每一行求和

本文介绍了如何使用Python处理多个CSV文件，包括在每行开头添加计算的日期差值（YYYY-MM-DD(3) - YYYY-MM-DD(2)），以及在每行末尾添加文件名。通过glob模块遍历目录中的CSV文件，csv模块读取和写入文件，以及datetime模块处理日期。最后，将所有处理后的行写入新的CSV文件。

摘要由CSDN通过智能技术生成

I have about 100 CSV files I have to operate on once a month and I was trying to wrap my head around this but I'm running into a wall. I'm starting to understand some things about Python, but combining several things is still giving me issues, so I can't figure this out.

Here's my problem:

I have many CSV files, and here's what I need done:

add a "column" to the front of each row (or the back, doesn't matter really, but front is ideal). In addition, each line has 5 rows (not counting the filename that will be added), and here's the format:

6-digit ID number,YYYY-MM-DD(1),YYYY-MM-DD(2),YYYY-MM-DD(3),1-2-digit number

I need to subtract YYYY-MM-DD(3) from YYYY-MM-DD(2) for every line in the file (there is no header row), for every CSV in a given directory.

I need the filename inside the row because I will combine the fil