为什么我要把两组数据减去。我想做一个元素一个元素的减法,我已经成功地提取了两个独立的集合,但是当我尝试用它做任何事情时,它总是给我一个NaN错误
这是我的代码:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
filename = 'vc_test.csv'
headings = 'injection', 'treatment','filename', 'l0', 'l1', 'l2', 'l3', 'filename', 'r0', 'r1', 'r2', 'r3'
#import data
df = pd.read_csv(filename, names=headings)
#convert values to floats
df['l0'] = df['l0'].astype(float)
df['l1'] = df['l1'].astype(float)
df['l2'] = df['l2'].astype(float)
df['l3'] = df['l3'].astype(float)
df['r0'] = df['r0'].astype(float)
df['r1'] = df['r1'].astype(float)
df['r2'] = df['r2'].astype(float)
df['r3'] = df['r3'].astype(float)
#group by injection so you have 2 subgroups
df.groupby(['injection'])
#subtract and assign to a different array to normalize data to baseline
df_os, df_od = df[['l1','l2','l3']].sub(df['l0'], axis=0), df[['r1','r2','r3']].sub(df['r0'], axis=0)
print df_os
print df_od
ioc = df_os - df_od
print ioc
我也试过了测向器()但没用。请帮忙。。。在
列名有问题-在两个被减除的
^{pr2}$DataFrames
中需要相等的列名。同样对于创建DataFrames
,您可以使用boolean indexing。在或者您可以通过^{} 将},然后减去:
DataFrames
转换为{相关问题 更多 >
编程相关推荐