Python3 - Pandas DataFrames

继续上一篇的博客，上一篇

import pandas as pd
import numpy as np

np.random.seed(101)
df = pd.DataFrame(np.random.randn(5,4),['A','B','C','D','E'],['W','X','Y','Z'])
print(df)

print("***** Find which values are > 0 *****")
print(df > 0)
print(df[df > 0])

print("**** Find some columns are > 0 ****")
print(df[['W','Y']] > 0)
print('\n')
print(df['W'] > 0)

print("****** Only find the numbers are > 0 *******")
print(df[df[['W','X','Y','Z']] > 0])

print("******* Only find the numbers are > 0 in one column ******")
print(df[df['W'] > 0])

print("*********")
print(df[df['Z'] < 0])

print("********")
print(df[df['W'] > 0])
print('\n')
print(df[df['W'] > 0]['X'])
print('\n')
print(df[df['W'] > 0][['X','Z']])

print("***** 多个条件选取条件 *****")
print(df[(df['W'] > 0) & (df['Y'] > 1)])

print("****** 获得index ******")
print(df.reset_index())

print("******* 添加一列 ******")
new_data = 'AA BB CC DD EE'.split()
print(new_data)
df['new_col'] = new_data
print(df)

print("***** 变化index名字 ******")
print(df.set_index('new_col'))
print('\n')
print(df)

结果如下：



如果觉得不错，就点赞或者关注或者留言~~
谢谢~ ~