DataFrame常用命令

最新推荐文章于 2024-06-22 16:54:28 发布

转载最新推荐文章于 2024-06-22 16:54:28 发布 · 487 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：https://juejin.im/post/5c1b100d5188252eb7596203

文章标签：

#python

本文深入探讨了Pandas库在数据处理方面的高级应用，包括DataFrame的创建、索引操作、数据清洗、聚合分析、文件读写及转换等关键功能。通过实例演示了如何使用Pandas进行高效的数据分析和处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

df = pd.DataFrame(np.random.randn(6,4), 
    index = ['one','two','three','four','five', 'six'], 
    columns = list('abcd'))

df.index
df.columns
df.head()
df.tail()
df['a']
df.loc['one']
df.loc[['one','four'],['a','c']]
df.iloc[3]
df.describe()
df.sort_values(by = 'c')
df.reindex([1,2,4,6])
df.reindex(index = [2,3], columns =['a','b'])
del df['a']
df.dropna(how = 'all')
df.fillna(0)


df.apply(lambda x : x.max() - x.min())
df['a'].apply | map(lambda x: x + 10)
df.applymap(lambda x: x + 10)
df.idxmax()
df.a.value_counts()[:10]

pd.read_csv('aaa.csv',sep = ',', skiprows = [0,1])
pd.read_csv('aaa.csv',headers = None, names = ['one','two'], nrows = 3)
data.to_csv('aaa.csv', index = False)
pd.read_excel('aaa.xslx', sheetname = 'ajfdla')
pd.read_csv('aaa.csv', index_col = 'location')


data.stack()
data.unstack()
data.duplicated()
data.drop_duplicated( |'one')
data.replace(2, np.nan)
data.k2.map(lambda x : x.replace("beijing", "shanghai"))
data.k2.str.replace("beijing", "shanghai")


bins = [0,10,20,30,40]
cats = pd.cut(data.k1, bins|4)
cats.value_counts()

groupby(df["animal"])['weight'].mean()
groupby("animal")['weight'].mean()
groupby("animal")['weight'].apply(lambda x: x - x.mean())
groupby("animal").size()

gb = groupby(['animal'])
gb.get_group('cat')

dic = {'a':'aa', 'b':'bb'}
data.columns = data.columns.map(lambda x: dic.get(x))
data.group(['leixing','gongzi'])['yuegongshi'].mean().unstack()

(data[['a','b','c']].isnull()).sum()
data = data[['a','b','c']].dropna()

复制代码