Create a new csv file with the column name using multiindex

Question

I am new to the python. Here, I have the following csv file which looks like ,

Prediction           per_RFC    per_JAPE

     100             100    97.37
    4600             100    86.15
    2200              80      80
    2900             100     100
    160              100     1.36
    3600             100      0
    2000             100      0

I have the features column like

feat_cols =[100,  156,  160,  162,  200,  256,  262,  2000,  2200,   2600,  2900,3600,4600]

Here, I am trying to get a csv which looks like

100  156  160  162  200  256  262  2000  2200   2600  2900       3600     4600
100       100                      100    80           100       100       100

So , I am trying to add the values from the csv in this file

can any one help me with this ?

thanks.

@dcg actually I tried but its a very wrong way so. could u please give a bit of hint or something ? — ganesh kaspate
– ganesh kaspate, Commented Dec 25, 2019 at 15:48

Valdi_Bo · Accepted Answer · 2019-12-25 16:00:45Z

2

To generate a DataFrame containing your expected content, run:

df2 = df.set_index('Prediction').per_RFC.reindex(feat_cols, fill_value='')\
    .reset_index().T

Then, to save it to a CSV file, run:

df2.to_csv('output.csv', header=False, index=False)

If you want the content saved just as you wrote (withot commas and with spaces between columns), you can:

generate a text variable: tt = df2.to_string(header=False, index=False),
save it to an ouptut file.

edited Dec 25, 2019 at 16:00

answered Dec 25, 2019 at 15:49

Valdi_Bo

31.1k4 gold badges29 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Create a new csv file with the column name using multiindex

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