在其中一个列中加入不同的列-python

import pandas as pd
dict1 = { 'col1' : ['4', '3', ' ', '6', '7', ' '],
      'col2' : [' ', ' ', '5', ' ', ' ', '8']}

df = pd.DataFrame.from_dict(dict1)
df

for i in range(df.shape[0]):
     if df.loc[i]['col1'] == ' ':
            df.loc[i]['col1'] = df.loc[i]['col2']      
df.drop('col2', axis=1)         

不是所有的空白都是 '' ,所以我们可以使用 pd.to_numeric 具有 errors = 'coerce' 然后填写 NaN 价值观 Series.fillna .

df['col1'] = pd.to_numeric(df['col1'],errors = 'coerce').fillna(df['col2'])