Hi can some one explain why it adds two 0 0 to my data frame in this function
JavaScript
x
17
17
1
def ToDF(ticker):
2
marketPriceP = []
3
marketPriceT = []
4
marketPriceT.append(t())
5
marketPriceP.append(currentPrice(ticker))
6
while True:
7
marketPriceT.append(t())
8
marketPriceP.append(currentPrice(ticker))
9
if len(marketPriceP) > 5:
10
MKpriceDF = pd.DataFrame(['Price'])
11
MKpriceDF1 = pd.DataFrame(['Time'])
12
MKpriceDF = MKpriceDF.append(marketPriceP, ignore_index= True, verify_integrity= False, sort= None)
13
MKpriceDF1 = MKpriceDF1.append(marketPriceT, ignore_index= True, verify_integrity= False, sort= None)
14
MKpriceDF = pd.concat([MKpriceDF1, MKpriceDF], axis= 1)
15
return MKpriceDF
16
break
17
the output looks like
JavaScript
1
9
1
0 0
2
0 Time Price
3
1 22:24:52 41.04
4
2 22:24:52 41.04
5
3 22:24:52 41.04
6
4 22:24:52 41.04
7
5 22:24:52 41.04
8
6 22:24:52 41.04
9
Advertisement
Answer
You may want to revisit how you are creating the dataframe. Here are some changes for you to consider. I have limited information about what you are doing so my answer is catering to just the code I have seen.
JavaScript
1
20
20
1
def ToDF(ticker):
2
marketPriceP = []
3
marketPriceT = []
4
marketPriceT.append(t())
5
marketPriceP.append(currentPrice(ticker))
6
while True:
7
marketPriceT.append(t())
8
marketPriceP.append(currentPrice(ticker))
9
if len(marketPriceP) > 5:
10
MKpriceDF = pd.DataFrame({'Price':marketPriceP, 'Time':marketPriceT})
11
return MKpriceDF
12
13
# MKpriceDF = pd.DataFrame(['Price'])
14
# MKpriceDF1 = pd.DataFrame(['Time'])
15
# MKpriceDF = MKpriceDF.append(marketPriceP, ignore_index= True, verify_integrity= False, sort= None)
16
# MKpriceDF1 = MKpriceDF1.append(marketPriceT, ignore_index= True, verify_integrity= False, sort= None)
17
# MKpriceDF = pd.concat([MKpriceDF1, MKpriceDF], axis= 1)
18
# return MKpriceDF
19
# break
20