我知道有类似的问题,但我没有找到我需要的确切场景:
我有一个输出多个日期的python脚本,例如,在第一节中,代码是:
print("All Subscriptions consumptions summary:")
for subscriptions in all_subscriptions_dic['results']:
#getting alist of variables from the function above
[subscription_name,subscription_type,available_sub,sub_consumed,sub_id]
sub_details = subscriptions_list(subscriptions)
redhat_subscriptions = rh_subs(sub_details[0])
if sub_details[1] == 'NORMAL' and redhat_subscriptions:
subscriptions_names_list.append(sub_details[0])
print("\n" + 'Subscription name:' + " " + sub_details[0])
print('Available_Subscriptions:' + " " + str(sub_details[2]))
print('Consumed subscriptions:' + " " + str(sub_details[3]))
并输出示例:(有更多的行)
All Subscriptions consumptions summary:
Subscription name: Red Hat Enterprise Linux Extended Life Cycle
Available_Subscriptions: 4
Consumed subscriptions: 0
Subscription name: Red Hat Enterprise Linux Server for HPC
Consumed subscriptions: 0
在另一个部分,我有一个循环,它使用print语句等输出一些其他数据
我想导出所有打印到屏幕上的数据,到excel或csv,如果这是不可能的。
至少,请告诉我除了上面的print语句之外,如何将数据添加到excel或csv文件中。
发布于 2018-03-01 02:09:08
这可能会对你有帮助
import csv
writer = csv.writer(open('subscriptions.csv', 'w'))
writer.writerow(['Subscription name', 'Available_Subscriptions:', 'Consumed subscriptions:'])
for sub_details in subscription_details:
writer.writerow([sub_details[0]], sub_details[2], sub_details[3])
https://stackoverflow.com/questions/49035728
复制相似问题