Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
ldempsey avatar image
1 ●0 ●0 ●1

ek.get_timeseries

How do i remove the extra row from my data set.

df = ek.get_timeseries (["CAD=;CAD1M=;CAD2M=;CAD3M=;CAD4M=;CAD5M=;CAD6M=;CAD7M=;CAD8M=;CAD9M=;CAD10M=;CAD11M=;CAD1Y="],

start_date="2024-01-01",

end_date="2024-03-31",

fields="CLOSE")

df

1710982008383.png


Thank you.

eikon-data-apiworkspace#technologypython api
1710982008383.png (30.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
85.2k ●290 ●53 ●77

@ldempsey

Thank you for reaching out to us.

Is it df.reset_index()?

1710989176818.png



1710989176818.png (32.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
ldempsey avatar image
1 ●0 ●0 ●1

That worked. I just added inplace to keep the change

df.reset_index(inplace=True)


Thank you.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.