/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 vote131 views1 answer
Python replace nth occurrence in string
Python
0 vote144 views1 answer
Copy files to a directory using text file
Python
0 vote142 views2 answers
How to count how many cameras you have with python
Python
0 vote180 views1 answer
Pypi modules for 3d gui
Python
0 vote147 views1 answer
Get users except superuser django
Python Django
0 vote153 views1 answer
Non blocking socket python
Python
31 votes132 views1 answer
UnicodeDecodeError: 'charmap' codec can't decode byte 0x9d in position 6148: character maps to <undefined>
Python
0 vote142 views1 answer
Ipynb to py online
Python
1 vote132 views2 answers
How to add watermark in mp4 video using python
Python
1 vote159 views1 answer
How to download excel file from s3 using python
Python