how creat a Dataframe from an array

Question

Im trying create a dataframe from array but I didnt have sucess.

    import investpy
    import pandas as pd

    result = ['BRKM5', 'MGLU3', 'PETR3', 'B3SA3', 'WEGE3']

    resultado =[]
    i=0
    for t in result:
    x = investpy.stocks.get_stock_information(t, 'brazil', as_json=False)    
    resultado.append(x.values)    
    i += 1

    df= pd.DataFrame(resultado, columns = ['Stock Symbol',
                            'Prev. Close',
                            'Todays Range',
                            'Revenue',
                            'Open',
                            '52 wk Range',
                            'EPS',
                            'Volume',
                            'Market Cap',
                            'Dividend (Yield)',
                            'Average Vol. (3m)',
                            'P/E Ratio',
                            'Beta',
                            '1-Year Change',
                            'Shares Outstanding',
                            'Next Earnings Date'])
df

ValueError: Shape of passed values is (5, 1), indices imply (5, 16)

kinshukdua · Accepted Answer · 2021-04-27 21:16:26Z

1

First set the parameter as_json as true in the line. According to the docs setting it to True makes the function return a dict (which is what you were probably expecting)

x = investpy.stocks.get_stock_information(t, 'brazil', as_json=True)

Then instead of using append use extend to add the values list of the dictionary values to the result list

resultado.extend(x.values())

Now everything should work.

edited Apr 27, 2021 at 21:16

answered Apr 27, 2021 at 20:42

kinshukdua

2,0041 gold badge7 silver badges15 bronze badges

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

3 Comments

Ricardo Proença Over a year ago

I tryed this @kinshukdua but with out sucess 'TypeError: 'numpy.ndarray' object is not callable'

kinshukdua Over a year ago

I've updated the answer, now it should work.

Ricardo Proença Over a year ago

I actually got it with set 'as_jason = True' . Thanks @kinshukdua

Collectives™ on Stack Overflow

how creat a Dataframe from an array

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related