/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

0 vote242 views1 answer
Tkinter background image python 3
Python
19 votes260 views1 answer
Python string cut
Python
0 vote232 views1 answer
Pandas read csv file header column not equal data columns
Python
39 votes227 views6 answers
Remove all whitespace from string python
Python
2 votes239 views2 answers
Coding the fibonacci sequence
Python
9 votes244 views1 answer
Pass argument to a py file
Python
3 votes199 views1 answer
Pygame unable to open file mp4
Python
0 vote232 views1 answer
Print 1 side of a dictionary python
Python
22 votes233 views4 answers
How to remove all characters after a specific character in python?
Python
9 votes249 views2 answers
Django model form import
Python Django