/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 vote291 views2 answers
Dd-mm-yy to yyyy-mm-dd in python
Python
0 vote285 views1 answer
Argparse python sentence
Python
5 votes297 views2 answers
Conda install spacy
Python
17 votes312 views4 answers
Count unique values in python
Python
0 vote299 views1 answer
At=error code=h10 desc= app crashed python flask
Python
0 vote288 views1 answer
Indent python code
Python
0 vote273 views2 answers
Jsonresponse status code django
Python
0 vote290 views1 answer
Cuantas palabras hay en una frase en python
Python
0 vote272 views1 answer
Dataframe time index convert tz naive to tz aware
Python
-1 vote292 views1 answer
Why women are better than men
Python