Extracting row data from a single column in a Python DataFrame

Question

Run the following code to identify the problem.

#Import the library
import amberelectric
from amberelectric.api import amber_api

import pandas as pd

configuration = amberelectric.Configuration(access_token =     'psk_954ef8ead8c4323b4fe73064186f6362')

# Create an API instance
api = amber_api.AmberApi.create(configuration)

sites = api.get_sites()

site_id = sites[0].id

today = api.get_prices(site_id)

#Print a DataFrame
data = pd.DataFrame(today)

#print(today)

print(type(data))

print(data.shape)

data1 = data.iloc[[0,1,2,3]]

print(data1)

Running the above code gives the following

<class 'pandas.core.frame.DataFrame'>
(48, 1)
                                               0
0  {'duration': 30.0, 'spot_per_kwh': 10.16542, '...
1  {'duration': 30.0, 'spot_per_kwh': 8.92124, 'p...
2  {'duration': 30.0, 'spot_per_kwh': 6.51428, 'p...
3  {'duration': 30.0, 'spot_per_kwh': 4.74366, 'p...

I understand that the result is a single column of 48 rows. But how can I extract the titles in the parenthesis (eg 'duration') from the single column? There are actually 12 headings that I would like to access and tabulate.

crx91 · Accepted Answer · 2022-11-09 05:15:17Z

1

I ran your code and realized although "today" looks like a list of dictionaries, it's actually not, so you need to convert to dictionary first before calling pd.DataFrame().

data = pd.DataFrame([i.to_dict() for i in today])

Now it's in tabular format

answered Nov 9, 2022 at 5:15

crx91

4832 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Extracting row data from a single column in a Python DataFrame

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