首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >转换Python返回到Excel

转换Python返回到Excel
EN

Stack Overflow用户
提问于 2018-07-12 02:43:02
回答 1查看 34关注 0票数 0

我必须用Correios在巴西的机构的所有信息创建一个Excel文件,我如何用我在最后打印的值创建一个Excel文件,这些值具有:

else:
lista_valores.append(text_info)
print(text_info)

我已经删除了所有的导入,因为stackoverflow说这篇文章的大部分代码。

My code:

FOLDER = r'D:\Users\gbenites\Desktop\Inovação\Correiosx'
chrome_path = r"D:\Users\gbenites\Desktop\Inovação\arquivos py\WebDriver\chromedriver.exe"
url = 'http://www2.correios.com.br/sistemas/agencias/'


driver = webdriver.Chrome(chrome_path)
driver.get("http://www2.correios.com.br/sistemas/agencias/")

file = open(FOLDER + 'Correios.csv', 'a', newline = '', encoding = 'utf-8')

#WebDriverWait(driver, 20).until(EC.presence_of_element_located((By.ID, 'municipioAgencia')))
driver.maximize_window()

lista_valores = []

time.sleep(3) 
estadoList = Select(driver.find_element_by_name('estadoAgencia'))


for index in range(1,len(estadoList.options)):
    select = Select(driver.find_element_by_name('estadoAgencia'))
    print("selecting Estado: ",select.options[index].text)       
    select.select_by_index(index)
    time.sleep(2)

    municípioList = Select(driver.find_element_by_name('municipioAgencia'))
    for index_b in range(1,len(municípioList.options)):
        select_b = Select(driver.find_element_by_name('municipioAgencia'))
        print("...selecting Municipio",select_b.options[index_b].text.replace("'",""))
        select_b.select_by_index(index_b)
        time.sleep(3)

        bairroList = Select(driver.find_element_by_name('bairroAgencia')) 
        for index_c in range(1,len(bairroslist)) 
            select_c = Select(driver.find_element_by_name('bairroAgencia'))
            print('...selecting Bairro',select_c.options[index_c].text.replace("'",""))
            select_c.select_by_index(index_c)
            time.sleep(3)

            #get_info_list =  WebDriverWait(driver, 10).until(EC.presence_of_all_elements_located((By.XPATH, "//table[@class = 'dadosAgencia']//td")))
            info_list = driver.find_elements_by_xpath("//table[@class = 'dadosAgencia']//span")
            td_list = driver.find_elements_by_xpath("//table[@class = 'dadosAgencia']//td")
            get_table_list = driver.find_elements_by_xpath("//table[@class = 'dadosAgencia']")


            for data in range(0,len(get_table_list)):
                for record in range(0,len(td_list)):
                        text_info = td_list[record].get_attribute('innerText') 
                        if text_info in lista_valores:
                            pass
                        else:
                            lista_valores.append(text_info)
                            print(text_info)
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2018-07-12 03:23:13

因此,如果我没记错的话,您希望将lista_valores转换为一个Excel文件。

pandas库是一种以DataFrame形式操作数据的可靠方法。

如果将import pandas as pd放置到导入中,请添加以下代码以从lista_valores创建exel工作表

result = pd.DataFrame(lista_valores)
result.to_csv('lista_valores.csv')

如果不知道lista_valores的数据类型以及text_info的数据类型,就很难理解这个问题。如果此解决方案不起作用,请改写或进一步解释您的问题。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/51292283

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档