How to eliminate the index value of columns and rows in a python dataframe?

Question

I am trying to eliminate the column and the row which state the index of the values and replace the first value of my column by 'kw'.

Have tried .drop without success

def main():

    df_old_m, df_new_m = open_file_with_data_m(file_old_m, file_new_m)
    #combine two dataframes together
    df = df_old_m.append(df_new_m)
    son=df["son"]
    gson=df["gson"]
    #add son
    df_old_m = df["seeds"].append(son)
    #add gson
    df_old_m = df_old_m.append(gson)
    #deleted repeated values
    df_old_m = df_old_m.drop_duplicates()

    #add kw as the header of the list
    df_old_m.loc[-1] = 'kw'  # adding a row
    df_old_m.index = df_old_m.index + 1  # shifting index
    df_old_m.sort_index(inplace=True)

This gives me .xlsx output

Nick · Accepted Answer · 2019-04-18 12:09:19Z

1

If kw is the column you want to be your new index, you can do this:

df.set_index('kw', inplace=True)

answered Apr 18, 2019 at 12:09

Nick

3,8586 gold badges36 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to eliminate the index value of columns and rows in a python dataframe?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related