python可视化：第七次作业pandas

 

 

 

# 1. (其它) 创建一个DataFrame对象，行索引为5名学生的学号，列索引包括:姓名 ，性别，年龄，籍贯。
import pandas as pd
data=[['张三','男','18','湖北'],['李四','女','20','湖北'],['王五','女','200','上海']]
df=pd.DataFrame(data,columns=['姓名','性别','年龄','籍贯'],index=[1001,1002,1003])
print(df)



# 2. (其它) 导入一个Excel文件，设置某一列为行索引，并输出前5条数据。

import pandas as pd
df=pd.read_excel(r'C:\Users\11059\Desktop\student_Table.xlsx',header=0)
print(df.head())




# 3. (其它) 将上一题中的Excel文件保存为csv文件，并编写代码导入此csv 文件的前3行数据。
#import pandas as pd
#df = pd.read_csv(r'C:\Users\11059\Desktop\nba.csv')
import pandas as pd
df=pd.read_excel(r'C:\Users\11059\Desktop\student_Table.xlsx',header=0)
xlsx_student=pd.DataFrame(df)
#保存为.csv格式文件
xlsx_student.to_csv(r'C:\Users\11059\Desktop\student_Table.csv',encoding='utf-8',index = False)

s_name=["张三1","张三2","张三3"]
s_id=["101","102","103"]
s_sex=["男","女","女"]
s_age=["230","120","110",]
dict1 = {'学号':s_id,'姓名':s_name,'性别':s_sex,'年龄':s_age}
pff=pd.DataFrame(dict1)

pff.to_csv(r'C:\Users\11059\Desktop\student_Table.csv',mode='a',header=False,encoding='utf-8',index = False)

df=pd.read_csv(r'C:\Users\11059\Desktop\student_Table.csv',encoding='utf-8')
csv_student=pd.DataFrame(df)
print(csv_student)







import pandas as pd

xlsx_student=pd.DataFrame(df)
df = pd.read_csv(r'C:\Users\11059\Desktop\student_Table.csv',nrows =3,encoding='utf-8')
print(df)