Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

292
Views
assign dtype with from_dict

I have data in a python dictionary like:

data = {u'01-01-2017 22:34:43:871': [u'88.49197', u'valid'],
        u'01-01-2017 11:23:43:803': [u'88.49486', u'valid'],
        u'02-01-2017 03:11:43:898': [u'88.49773', u'valid'],
        u'01-01-2017 13:54:43:819': [u'88.50205', u'valid']}

I can convert it to a pandas Dataframe with:

data = pandas.DataFrame.from_dict(data, orient='index')

but I am not able to use the dtype parameter of from_dict. I would convert the index to a datetime of similar first column to float and third to string.

I have tried:

pandas.DataFrame.from_dict((data.values()[0]), orient='index', 
                                               dtype={0: 'float', 1:'str'})

but it doesn't work.

over 4 years ago · Santiago Trujillo
1 answers
Answer question

0

This appears to be an ongoing issue with some of the pandas constructor methods: How to set dtypes by column in pandas DataFrame

Instead of using the dtype argument, chaining .astype may do the trick:

pandas.DataFrame.from_dict(data, orient='index').astype({0: float, 1:str})
over 4 years ago · Santiago Trujillo Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!