我试图用python解析csv文件并打印每天的order_total总和。下面是示例csv文件order_total created_datetime
24.99 2015-06-01 00:00:12
0 2015-06-01 00:03:15
164.45 2015-06-01 00:04:05
24.99 2015-06-01 00:08:01
0 2015-06-01 00:08:23
46.73 2015-06-01 00:08:51
0 2015-06-01 00:08:58
47.73 2015-06-02 00:00:25
101.74 2015-06-02 00:04:11
119.99 2015-06-02 00:04:35
38.59 2015-06-02 00:05:26
73.47 2015-06-02 00:06:50
34.24 2015-06-02 00:07:36
27.24 2015-06-03 00:01:40
82.2 2015-06-03 00:12:21
23.48 2015-06-03 00:12:35
我的目标是每天打印sum(order_total)。例如,结果应该是2015-06-01 -> 261.16
2015-06-02 -> 415.75
2015-06-03 -> 132.92
我已经编写了下面的代码-它还没有执行逻辑,但是我正在尝试通过打印一些示例语句来查看它是否能够按照要求进行解析和循环。你知道吗def sum_orders_test(self,start_date,end_date):
initial_date = datetime.date(int(start_date.split('-')[0]),int(start_date.split('-')[1]),int(start_date.split('-')[2]))
final_date = datetime.date(int(end_date.split('-')[0]),int(end_date.split('-')[1]),int(end_date.split('-')[2]))
day = datetime.timedelta(days=1)
with open("file1.csv", 'r') as data_file:
next(data_file)
reader = csv.reader(data_file, delimiter=',')
if initial_date <= final_date:
for row in reader:
if str(initial_date) in row[1]:
print 'initial_date : ' + str(initial_date)
print 'Date : ' + row[1]
else:
print 'Else'
initial_date = initial_date + day
根据我目前的逻辑我遇到了这个问题-正如您在示例csv中看到的,2015-06-01有7行,2015-06-02有6行,2015-06-03有3行。你知道吗
上面代码的输出是为2015-06-01打印7个值,为2015-06-02打印5个值,为2015-06-03打印2个值
使用sum_orders_test('2015-06-01','2015-06-03');调用函数
我知道有一些愚蠢的逻辑问题,但作为编程和python的新手,我无法理解它。你知道吗