/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 vote134 views1 answer
Mak a scipy csr sparse matrix
Python
-2 votes143 views2 answers
Float() argument must be a string or a number, not 'dict_values'
Python
7 votes142 views3 answers
Sklearn random forest regressor
Python
1 vote202 views1 answer
Flask api with parameter
Python Flask
75 votes135 views4 answers
Download pip install
Python
0 vote148 views1 answer
TypeError: unhashable type: 'list' drop duplicates
Python
5 votes154 views4 answers
Python save dictionary to file
Python
0 vote131 views1 answer
Check tensor type tensorflow
Python
0 vote152 views1 answer
Ssl expired python
Python
0 vote147 views2 answers
Message: 'geckodriver' executable needs to be in PATH.
Python