copy selected columns from one dataframe to another code example

Example 1: python create new pandas dataframe with specific columns

# Basic syntax:
new_dataframe = old_dataframe.filter(['Columns','you','want'], axis=1)

Example 2: select columns to include in new dataframe in python

new = old.filter(['A','B','D'], axis=1)

Example 3: pandas copy data from a column to another

df = pd.DataFrame()

df['X'] = [0, 3, 1, 1, 2, 2, 3, 3, 1, 2]
df['Y'] = [111.0, np.nan, np.nan, 112, 113, np.nan, 114, 115, np.nan, 116]

df['Y'] = df['Y'].fillna(df['X'])

print(df)