数据处理
一行代码替换空值和非空值
b['label'] = b['text_a'].isna().map({True:0, False:1})
删除一行或一列
full.drop(['label'], axis=0)
full.drop(['label'], axis=1)
从已有dataframe取几列成为新的dataframe
TPP=full[['Title','Pclass','Parch']]
两个dataframe合并成一个python 把几个DataFrame合并成一个DataFrame——merge,append,join,conca
pd.merge(left, right, how='inner', on=None, left_on=None, right_on=None,
left_index=False, right_index=False, sort=True,
suffixes=('_x', '_y'), copy=True, indicator=False)
tensor与ndarry转换
DataFrame、Series、array、tensor的创建及相互转化
#tensor->ndarry
#方法一
z = tf.random_normal([2, 3])
with tf.Session():
z_np = z.eval()
print(z_np)
#方法二
z = tf.random_normal([2, 3])
sess = tf.Session()
z_np = sess.run(z)
print(z_np)
#ndarry->tensor
tensor_a=tf.convert_to_tensor(a)
print(tensor_a)
添加/删除/替换 numpy数组中的某一列
# axis=0为行操作, axis=1为列操作
import numpy as np
a = np.zeros((2,2), dtype=np.int)
print("a:",a)
# 替换某列
a[::,0] = [1, 1]
print("a:",a)
# 删除某列
b = np.delete(a,0,axis=1)
print("b:",b)
# 添加某列
c = np.insert(a, 0, values=b, axis=1)
print("c:",c)
# 插入一列0
a = np.zeros(len(b))
print(a)
b = np.insert(b, 0, values=a, axis=1)
out:
a: [[0 0]
[0 0]]
a: [[1 0]
[1 0]]
b: [[0]
[0]]
c: [[0 0 1 0]
[0 0 1 0]]