/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

4 votes222 views1 answer
How to make a custom icon for pygame
Python
19 votes239 views2 answers
How to avoid deprecation warning in python
Python
1 vote227 views1 answer
Python sleep random
Python
0 vote202 views1 answer
How to resolve This typically means that you attempted to use functionality that needed an active HTTP request. Consult the documentation on testing for information about how to avoid this problem. in thread python
Python
0 vote233 views1 answer
%%writefile
Python
0 vote239 views1 answer
Requests.Session() proxies
Python
2 votes211 views1 answer
Firebase-admin python
Python
0 vote212 views1 answer
Paschat opposite sanskrit
Python
1 vote220 views1 answer
Python ssh library
Python
0 vote205 views1 answer
How to get ********** on python
Python