python操作csv文件

csv comma-separated values 逗号分隔值，有时也被称为字符分隔值，其以文本形式存储表格数据

read_csv（）读取csv文件内容

import  pandas as pd
df = pd.read_csv(r"C:\Users\wang\Desktop\a.csv")
print(df)

to_csv（）写入文件

import  pandas as pd
nme = ["Google","Baidu","Huawei","Wiki"]
st = ["google.com","baidu.com","huawei.com","wiki.com"]
ag = [90,80,40,50]
dict = {'name':nme,'site':st,'age':ag}
df = pd.DataFrame(dict)
df.to_csv('site.csv')

head（）读取csv文件前几行，不写数字默认5行

import  pandas as pd
df = pd.read_csv(r"C:\Users\wang\Desktop\a.csv")
print(df.head())

tail（）读取文件csv文件后几行，不写数字默认5行

import  pandas as pd
df = pd.read_csv(r"C:\Users\wang\Desktop\a.csv")
print(df.tail())

info方法返回表格的一些基本信息

import pandas as pd
df = pd.read_csv(r"C:\Users\wang\Desktop\a.csv")
print(df.info())