/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

21 votes183 views3 answers
Python if not null or empty
Python
0 vote164 views1 answer
Pyspark reduce a list
Python
1 vote142 views1 answer
Programe to check if a is divisible
Python
1 vote118 views2 answers
Fibonacci python
Python
8 votes148 views6 answers
Python int to binary
Python
-1 vote183 views1 answer
The field was declared on serializer, but has not been included in the 'fields' option
Python
0 vote165 views1 answer
How to make every item compare the rest items of list in python
Python
0 vote150 views1 answer
Blender python save file
Python
15 votes156 views1 answer
One-line for loop python
Python
4 votes189 views1 answer
When was python developed
Python