Python_Pandas_Series_DataFrame练习题

一、基本的Series操作

1、可以基于一个list构造一个 s = Series([3, 8, -5, 1]) ，要求列表里的内容为学生本人学号，示范如下：

import pandas as pd
s = pd.Series([2,0,1,9,2,7,5,5,0,2,4,3])
print(s)

2、访问Series对象的values属性和index属性

import pandas as pd
s = pd.Series([2,0,1,9,2,7,5,5,0,2,4,3])
print(s.index)
print(s.values)

3、任意访问单个元素值

import pandas as pd
s = pd.Series([2,0,1,9,2,7,5,5,0,2,4,3])
print(s[8])

4、通过index列表选择Series对象的多个元素值

import pandas as pd
s = pd.Series([2,0,1,9],index=['a','b','c','d'])
print(s['a'],s[1])

5、讲Series对象和一个实数做算术运算

import pandas as pd
s = pd.Series([2,0,1,9],index=['a','b','c','d'])
print(s*3)

6、Series对象和一个实数做逻辑运算

import pandas as pd
s = pd.Series([2,0,1,9],index=['a','b','c','d'])
print(s>0) #输出的结果为序列中的每一项都进行逻辑运算

7、完成一些map的操作

import pandas as pd
s = pd.Series([2,0,1,9],index=['a','b','c','d'])
print('a' in s) #map操作

8、通过赋值能够改变Series对象value

import pandas as pd
s = pd.Series([2,0,1,9],index=['a','b','c','d'])
s["d"]=3      #改变的是s的值
print(s)

9、通过赋值改变Series对象的index

import pandas as pd
s = pd.Series([2,0,1,9],index=['a','b','c','d'])
s.index=list('wxyz') #改变index
print(s)

10、基于字典创建Series对象

from pandas import Series
s = Series({"a":1,"b":2,"c":3})
print(s)

11、创建Series对象的指定index

import pandas as pd
s = pd.Series([1,2,3,4],index=['a','b','c','d'])
print(s)

二、基本的DataFrame操作

1、基于字典构造一个DataFrame对象

from pandas import DataFrame
data = {"int_column":[1,2,3],"string_column":[3.3,4.4,5.5],"folat_column":['a','b','c']}
df = DataFrame(data)
print(df)

2、获取DataFrame对象的任意一列，并且查看其类型

from pandas import DataFrame
data = {"int_column":[1,2,3],"string_column":[3.3,4.4,5.5],"folat_column":['a','b','c']}
df = DataFrame(data)
a = df['int_column']
print(a) 

3、DataFrame对象具有一些基本的统计方法，它们是按列进行计算的，返回的结果是一个Series对象。 要求计算每列的均值和每列之和。

from pandas import DataFrame
data = {"int_column":[1,2,3],"string_column":[3.3,4.4,5.5],"folat_column":['a','b','c']}
df = DataFrame(data)
a = df.sum()
print(a)

4、DataFrame对象之间也可以进行一些基本计算，是以列名找出匹配的列进行计算，进行简单的加法运算

from pandas import DataFrame
df1 = DataFrame({"a":[1,2,3],"b":[3.3,4.4,5.5],"c":['a','b','c']})
df2 = DataFrame({"a1":[4,5,6],"b1":[6.6,7.7,8.8],"c1":['aa','bb','cc']})
print(df1+df2)
a = df1['a']+df2['a1']
print(a)

三、文件的导入与导出

1、利用函数read_csv()和read_table()读入“test.csv”

import pandas as pd
df = pd.read_csv("test.csv")
print(df)
import pandas as pd
df = pd.read_table("test.csv",sep=',') #使用read_table时要切片
print(df)

2、基于mymovie对象，获取片名、票房、时间这三列，并且通过to_csv()导出一个“movies_1.csv”文件，如下：

import pandas as pd
mymovies = pd.read_csv("C:/Users/30627/Desktop/movies.csv",sep=",",names=["片名","未知","占比1","观看次数","比例2","上映天数","比例3"
                                                                   ,"票房","天数","时间"])    #csv文件可自主，主要看写法
print(mymovies)
mymovies.to_csv("C:/Users/30627/Desktop/movies_1.csv",columns=["片名","票房","时间"])