/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 vote318 views2 answers
Matplotlib display graph on jupyter notebook
Python
8 votes312 views3 answers
Scikit learn roc curve
Python
0 vote341 views1 answer
Python change type of every element in a dictionary
Python
1 vote334 views2 answers
Count the number of cells that contain a specific value in a pandas dataframe python
Python
27 votes327 views2 answers
What value do we get from NULL database python
Python
28 votes333 views4 answers
Pygame scale image
Python
1 vote318 views1 answer
Sheebang python
Python
1 vote331 views1 answer
Increase contrast cv2
Python
0 vote318 views1 answer
From decimal to binary python without using any libraries
Python
3 votes352 views2 answers
Python button click code
Python