/Python/Adding new column to existing DataFrame in Pandas

Adding new column to existing DataFrame in Pandas

How to add a column to a pandas df

#using the insert function:
df.insert(location, column_name, list_of_values) 
#example
df.insert(0, 'new_column', ['a','b','c'])
#explanation:
#put "new_column" as first column of the dataframe
#and puts 'a','b' and 'c' as values

#using array-like access:
df['new_column_name'] = value

#df stands for dataframe

Python how to add columns to a pandas dataframe

# Basic syntax:
pandas_dataframe['new_column_name'] = ['list', 'of', 'column', 'values']

# Note, the list of column values must have length equal to the number
# 	of rows in the pandas dataframe you are adding it to.

# Add column in which all rows will be value:
pandas_dataframe['new_column_name'] = value
# Where value can be a string, an int, a float, and etc

Source: pythonexamples.org

Adding new column to existing DataFrame in Pandas

# import pandas library
import pandas as pd

# create pandas DataFrame
df = pd.DataFrame({'team': ['India', 'South Africa', 'New Zealand', 'England'],
                   'points': [10, 8, 3, 5],
                   'runrate': [0.5, 1.4, 2, -0.6],
                   'wins': [5, 4, 2, 2]})

# print the DataFrame
print(df)


# insert the new column at the specific position
df.insert(3, "lost", [2, 1, 3, 4], True)

# Print the new DataFrame
print(df)

Source: itsmycode.com

Adding new column to existing DataFrame in Pandas using assign method

# import pandas library
import pandas as pd

# create pandas DataFrame
df = pd.DataFrame({'team': ['India', 'South Africa', 'New Zealand', 'England'],
                   'points': [10, 8, 3, 5],
                   'runrate': [0.5, 1.4, 2, -0.6],
                   'wins': [5, 4, 2, 2]})

# print the DataFrame
print(df)

# append multiple columns to Pandas DataFrame
df2 = df.assign(lost=[2, 1, 3, 4], matches_remaining=[2, 3, 1, 1])

# Print the new DataFrame
print(df2)

Source: itsmycode.com

Adding new column to existing DataFrame in Pandas by assigning a list

# import pandas library
import pandas as pd

# create pandas DataFrame
df = pd.DataFrame({'team': ['India', 'South Africa', 'New Zealand', 'England'],
                   'points': [10, 8, 3, 5],
                   'runrate': [0.5, 1.4, 2, -0.6],
                   'wins': [5, 4, 2, 2]})

# print the DataFrame
print(df)

# declare a new list and add the values into the list
match_lost = [2, 1, 3, 4]

# assign the list to the new DataFrame Column
df["lost"] = match_lost

# Print the new DataFrame
print(df)

Source: itsmycode.com

Add dataframe column to set

set_id = set(df["Id"])
print(set_id)
{'1-wYH2LEcmk', '08QMXEQbEWw', '0pPU8CtwXTo', '0ANuuVrIWJw', '-KkJz3CoJNM'}

-1

Source: stackoverflow.com

Similar codes

0 vote121 views1 answer
Supercharged python
Python
3 votes126 views3 answers
Python get script path
Python
0 vote109 views1 answer
How to crash a pc using python
Python
92 votes117 views6 answers
Python choose random element from list
Python
0 vote115 views1 answer
Pandas concat / merge two dataframe within one dataframe
Python
0 vote112 views1 answer
Python format method align center
Python
0 vote124 views2 answers
Python to c converter tool
Python
0 vote119 views1 answer
Longest Palindromic Substring using DP
Python
0 vote105 views1 answer
Rest plus
Python
8 votes153 views2 answers
What does class meta do in django
Python Django