Convert array of dicts to timestamp-indexed DataFrame

Asked Dec 14 '22 at 07:03

Active Dec 14 '22 at 07:11

Viewed 21 times

ts should be index (Unix time in milliseconds), column name is random string.

[
    {'ts': 1669246574000, 'value': '6.06'}, 
    {'ts': 1669242973000, 'value': '6.5'}
]

I would like to have the following output

DT index         SomeParam
1669242973000    6.5
1669246574000    6.06

Instead of

DT index    ts               SomeParam
0           1669242973000    6.5
1           1669246574000    6.06

edited Dec 14 '22 at 07:11

asked Dec 14 '22 at 07:03

devaskim

`pd.DataFrame( [ {'ts': 1669246574000, 'value': '6.06'}, {'ts': 1669242973000, 'value': '6.5'} ])` – wwnde Dec 14 '22 at 07:05
As I understand DataFrame format it would be 2-column frame with index 0,1...N – devaskim Dec 14 '22 at 07:06
1

Use `pd.DataFrame(L).set_index('ts')` – jezrael Dec 14 '22 at 07:12
@jezrael Great. Do you know how to replace `value` column name with `SomeParam`? – devaskim Dec 14 '22 at 07:15
@jezrael I [found](https://stackoverflow.com/questions/11346283/renaming-column-names-in-pandas) the answer – devaskim Dec 14 '22 at 07:19

0 Answers0