Trouble Creating Dataframe from Arrays

Question

I want to create a DataFrame with separate columns for PY and ST, however the DataFrame is created with index values of PY.

import numpy as np
import pandas as pd 
import matplotlib.pyplot as plt 

K = 8000 

ST = np.linspace(7000,9000,num=50)  

PO = 50 

PY = np.maximum(ST-K-PO,0)

pd.DataFrame(PY,ST)

Is there a way to create the DataFrame with default index starting from 0 and 2 columns of PY and ST.

Your index values are ST not PY.

kpie
– kpie

2022-01-15 04:25:28 +00:00
Commented Jan 15, 2022 at 4:25 — kpie
– kpie, Commented Jan 15, 2022 at 4:25

kpie · Accepted Answer · 2022-01-15 04:16:43Z

1

You can use df = pd.DataFrame(list(zip(PY,ST)),columns=["py","st"])

answered Jan 15, 2022 at 4:16

kpie

11.2k7 gold badges33 silver badges53 bronze badges

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

2 Comments

Data_Artist Over a year ago

Thank you. Appreciate your help. Is there a reason why first column is taken index ?

kpie Over a year ago

Yeah index is the second argument to pandas.DataFrame. pandas.pydata.org/docs/reference/api/pandas.DataFrame.html

Collectives™ on Stack Overflow

Trouble Creating Dataframe from Arrays

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related