pandas数据分析

1、用loc[行标签]输出行数据

import pandas as pd
import numpy as np

d={'one':pd.Series([1,2,3],index=['a','b','c']),
   'two':pd.Series([1,2,3,4],index=['a','b','c','d'])}

df=pd.DataFrame(d)
print(df.loc['b'])
输出：

one 2.0
two 2.0
Name: b, dtype: float64

2、将整数位置传递给iloc（）函数来选择行

import pandas as pd
import numpy as np

d={'one':pd.Series([1,2,3],index=['a','b','c']),
   'two':pd.Series([1,2,3,4],index=['a','b','c','d'])}

df=pd.DataFrame(d)
print(df.iloc[2])

3、添加或删除行

import pandas as pd
import numpy as np

df1=pd.DataFrame([[1,2],[3,4]],columns=['a','b'])

df2=pd.DataFrame([[5,6],[7,8]],columns=['a','b'])

df=df1.append(df2)
print(df)
df=df.drop(0)
print(df)
输出：

a b
0 1 2
1 3 4
0 5 6
1 7 8
a b
1 3 4
1 7 8

4、