在Python中格式化CSV文件的输出 [英] Formatting output of CSV file in Python
问题描述
姓名,电话,公司,电子邮件
Elon Musk,454-6723,SpaceX,emusk @ spacex.com
Larry Page,853-0653,Google,lpage @ gmail.com
Tim Cook,133-0419,Apple, tcook@apple.com
Steve Ballmer,456-7893,Developers!,sballmer @ bluescreen.com
我试图格式化输出,使其看起来更干净,更具可读性,即所有东西排成行和列。 code>姓名:电话:公司:电邮:
Elon Musk 454-6723 SpaceX emusk@spacex.com
我现在的代码如下所示:
$ $ $ $ $ $ $ c $ f $ open(contactlist.csv)
csv_f = csv.reader(f)
用于csv_f中的行:
print(row)
这自然是由于缺乏格式化而产生的,这看起来还是很不洁净的。
['Name','Phone','Company','Email']
['Elon Musk','454-6723','SpaceX ','emusk@spacex.com']
['Larry Page','853-0653','Google','lpage@gmail.com']
['Tim Cook','133 -0419','Apple','tcook@apple.com']
['Steve Ballmer','456-7893','Developers!','sballmer@bluescreen.com']
有关如何生成更清晰的输出的任何提示将不胜感激,因为我是初学者,我发现所有这些令人困惑。非常感谢。
您可以使用格式
你的输出。例如,
f = open(contactlist.csv)
csv_f = csv.reader(f)
for row in csv_f:
print('{:< 15} {:< 15} {:20} {:25} .format(* row))
输出:
姓名电话公司电子邮件
Elon Musk 454-6723 SpaceX emusk@spacex.com
Larry页面853-0653 Google lpage@gmail.com
Tim Cook 133-0419 Apple tcook @ apple。 com
Steve Ballmer 456-7893开发者! sballmer@bluescreen.com
您可以阅读更多关于格式在这里。 <
符号左对齐文本,数字指定字符串的宽度。每个 {}
可以在冒号之前包含位置参数: - 如果省略,字符串将出现在code> row
。
I am creating a very rudimentary "Address Book" program in Python. I am grabbing contact data from a CSV file, the contents of which looks like the following example:
Name,Phone,Company,Email
Elon Musk,454-6723,SpaceX,emusk@spacex.com
Larry Page,853-0653,Google,lpage@gmail.com
Tim Cook,133-0419,Apple,tcook@apple.com
Steve Ballmer,456-7893,Developers!,sballmer@bluescreen.com
I am trying to format the output so that it looks cleaner and more readable, i.e. everything lined up in rows and columns, like this:
Name: Phone: Company: Email:
Elon Musk 454-6723 SpaceX emusk@spacex.com
My current code is as follows:
f = open("contactlist.csv")
csv_f = csv.reader(f)
for row in csv_f:
print(row)
Which naturally due to lack of formatting, produces this, which still looks very unclean.
['Name', 'Phone', 'Company', 'Email']
['Elon Musk', '454-6723', 'SpaceX', 'emusk@spacex.com']
['Larry Page', '853-0653', 'Google', 'lpage@gmail.com']
['Tim Cook', '133-0419', 'Apple', 'tcook@apple.com']
['Steve Ballmer', '456-7893', 'Developers!', 'sballmer@bluescreen.com']
Any tips on how to produce a cleaner output would be greatly appreciated, as I am beginner and I find all of this quite confusing. Many thanks in advance.
You could use format
to left justify your output. For example,
f = open("contactlist.csv")
csv_f = csv.reader(f)
for row in csv_f:
print('{:<15} {:<15} {:<20} {:<25}'.format(*row))
Output:
Name Phone Company Email
Elon Musk 454-6723 SpaceX emusk@spacex.com
Larry Page 853-0653 Google lpage@gmail.com
Tim Cook 133-0419 Apple tcook@apple.com
Steve Ballmer 456-7893 Developers! sballmer@bluescreen.com
You can read more about format here. The <
symbol left-aligns the text, and the number specifies the width of the string. Each {}
can include a positional argument before the colon :
- if they are omitted, the strings will appear in the order of the arguments in the unpacked list row
.
这篇关于在Python中格式化CSV文件的输出的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!