Answers for "how to set two columns as index in pandas"

3

set index to column pandas

df = df.set_index('col')
df['col'] = df.index
Posted by: Guest on December-01-2020
0

pandas combine two data frames with same index and same columns

pd.merge(df1, df2, left_index=True, right_index=True, how='outer')
Posted by: Guest on April-21-2020
0

python - join two columns and transform it as index

df = DataFrame({'var_1':['a','b','c'], 'var_2':[1, 2, 3], 'var_3':['apple', 'banana', 'pear']})
cols = ['var_1', 'var_2']    # Set columns to combine
df['combined'] = df[cols].apply(lambda row: ', '.join(row.values.astype(str)), axis=1)

# Define which column is index
df_i = df.set_index('combined') 

# Set the index to None
df_i.index.names = [None]
Posted by: Guest on September-04-2020

Code answers related to "how to set two columns as index in pandas"

Python Answers by Framework

Browse Popular Code Answers by Language