公司要我做报表，只会随机数据图表的我感到危机感，来试试Python读取csv

Python 读取csv

---

---

输出所有行

import csv
with open("GDP_MAP.csv","r") as f:
    reader=csv.reader(f)
    rows=[row for row in reader]
print(rows)

输出某一列【不急，全部列的输出，我们等下来试试】

import csv
with open("GDP_MAP.csv","r") as f:
    reader=csv.reader(f)
    rows=[row[0] for row in reader]
print(rows)

这就输出了第一列。

输出所有列

import csv
global total
with open("GDP_MAP.csv","r") as k:
    reader = csv.reader(k)
    rows3 = [row for row in reader]
    row_1=[]
    row_1=rows3[0]
    #print(row_1)
    total=len(row_1)
    #print(total)
for i in range(0,total):
    with open("GDP_MAP.csv","r") as f:
            reader=csv.reader(f)
            rows2 = [row[i] for row in reader]
            print(rows2)

因为没有固定的全部读取内置函数，这个思路就是读取一行，确定元素个数，让我知道有多少列，再利用循环进行赋值输出，就相当于获得了所有哦列的输出。

DictReader输出字典

import csv
with open('GDP_MAP.csv','r') as csvfile:
    reader = csv.DictReader(csvfile)
    rows = [row for row in reader]
print(rows)

DictReader输出可用字典

import csv
with open('GDP_MAP.csv','r') as csvfile:
    reader=csv.reader(csvfile)
    fieldnames=next(reader)
    csv_reader = csv.DictReader(csvfile,fieldnames=fieldnames)
    for row in csv_reader:
        d={}
        for k,v in row.items():
            d[k]=v
        print (d)

就介绍到这里。