Python pandas,pandas读取外部数据,读取csv格式数据(read_csv)
demo.py(pandas读取csv中的数据):
# coding=utf-8
import pandas as pd
# pandas读取csv中的数据
df = pd.read_csv("./dogNames.csv") # 默认把第一行当成标题(列索引)
print(type(df)) # <class 'pandas.core.frame.DataFrame'>
print(df)
'''
Row_Labels Count_AnimalName
0 MARCH 2
1 APRIL 51
2 AUGUST 14
3 DECEMBER 4
4 SUNDAY 13
5 MONDAY 4
6 FRIDAY 19
7 JAN 1
8 JUN 1
9 JANUARY 1
'''
# pandas读取mysql中的数据
# df2 = pd.read_sql(sql_sentence,connection)
./dogNames.csv(csv格式数据):
Row_Labels,Count_AnimalName
MARCH,2
APRIL,51
AUGUST,14
DECEMBER,4
SUNDAY,13
MONDAY,4
FRIDAY,19
JAN,1
JUN,1
JANUARY,1
还没有评论,来说两句吧...