/Python/Python add columns to dataframe without changing the original

Python add columns to dataframe without changing the original

#given an original pandas.DataFrame named 'df', and the data series that we want to associate with the new column named 's', 3 possible solutions:

#1-Use "assign()" to create new column and then assign values to it
df_w_new_col = df.assign (name='New_Col')

#2-create an aditional Dataframe with just the new column to add and concatenate with the old dataframe. Like a great majority of pandas methods, this actually creates a new df, it does not just concatenate to the old one so it is safe to change the old and new df's independetly
df = pd.concat( [df, pd.DataFrame({'New_Col:s})], axis=1 )

#3-explicitely create a copy and append a column
df2 = df.copy()
df2['New_Col'] = s

Similar codes

1 vote142 views1 answer
Cannot import name 'joblib' from 'sklearn.externals' (/shared-libs/python3.7/py/lib/python3.7/site-packages/sklearn/externals/__init__.py)
Python
19 votes194 views1 answer
Python turn of userwarning
Python
0 vote221 views1 answer
Python numpy kurtosis
Python
1 vote212 views1 answer
How to replace the last character of a string in python
Python
2 votes185 views1 answer
Give a function a name python
Python
0 vote201 views1 answer
What is iterator in python
Python
0 vote198 views1 answer
Convert string ranges list python
Python
2 votes205 views3 answers
For loop inclusive python
Python
1 vote218 views2 answers
Django unique_together
Python
0 vote211 views1 answer
How to check how many cameras are connected to device in python\
Python