Create a DataFrame from another DataFrame by column

Question

I would like to create a data frame from another data frame - but I want to do it by specifying the coordinates. In this case I want the new DataFrame to contain only the first column.

The following is correct in that it works:

US_effective_rate = US_forward_rates.iloc[:,1].copy()
US_effective_rate = US_effective_rate.to_frame()

I was wondering if there's a better implementation, possibly using .filter()?

there are similar questions but they reference column names, not coordinates.

thank you very much.

PS: I actually just want the dimensions and index from the first frame, going to overwrite the actual data. Any chance I could do THAT in one hit?

BENY · Accepted Answer · 2019-09-04 00:54:11Z

1

Yes you can just add []

US_forward_rates.iloc[:,[1]]

answered Sep 4, 2019 at 0:54

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

Tikhon Over a year ago

Boom! Thank you so much!

Collectives™ on Stack Overflow

Create a DataFrame from another DataFrame by column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related