creating a Data Frame from python file

Viewed 25

Hey all I am new to python.I need your help to create a data frame.

I need 5 columns in my dataframe. Data is in nested form.under category we have different services under every service there are different profiles and under profile we have os and price.


Category     service         profile                         OS           price
Com             ABC            SMALL                      Windows8         2
Com             ABC            SMALL                        linux          10
Com             ABC            medium                      windows8        10
Com             ABC            medium                      linux           20
DB              XYZ             VP                                         2
DB             XYZ             ram                                         4


ABC={
     'SMALL': {
               'Windows8':2,
                'linux':10
              },
     'medium':{
            'Windows8':10,
            'linux': 20
            }
          },
XYZ={
      'Vp':2,
      'ram':4
    }
0 Answers
Related