Search code examples
pythonpandasdictionarydataframedata-analysis

creating a dataframe using a dictionary with new columns in pandas in python


hi I have a dictionary,

 d={'Pricing': 1, 'Product': 1, 'Rates': 2, 'one': 1}
 columnsd=["one","two"]

I tried,

  df=pd.DataFrame(d,columns=columnsd)

I am getting,

 ValueError: If using all scalar values, you must pass an index

my desired df should be,

   one          two    
   Pricing       1
   Product       1
   Rates         2
   one           1

Solution

  • Convert to tuples and use pd.DataFrame/pd.DataFrame.from_records:

    pd.DataFrame.from_records(list(d.items()), columns=columnsd)
    
           one  two
    0  Product    1
    1      one    1
    2  Pricing    1
    3    Rates    2