Power Query & Python - Loader Data

 let

    Source = Python.Execute("import pandas as pd#(lf)import investpy#(lf)data = [['brazil','AstraZeneca PLC','AstraZeneca PLC','.'   , 'BRL'   ,'A1ZN34' ] ]#(lf)data = pd.DataFrame(data,columns=['country',  'name',  'full_name',  'isin',  'currency',  'symbol'])#(lf)df_stocks = investpy.get_stocks(country='Brazil')#(lf)df_stocks = df_stocks.append([data], sort=False)#(lf)dataset = df_stocks"),

    dataset1 = Source{[Name="dataset"]}[Value]

in

    dataset1

Python Code:

import pandas as pd

import investpy

data = [['brazil','AstraZeneca PLC','AstraZeneca PLC','.'   , 'BRL'   ,'A1ZN34' ] ]

data = pd.DataFrame(data,columns=['country',  'name',  'full_name',  'isin',  'currency',  'symbol'])

df_stocks = investpy.get_stocks(country='Brazil')

df_stocks = df_stocks.append([data], sort=False)

dataset = df_stocks