社区所有版块导航
Python
python开源   Django   Python   DjangoApp   pycharm  
DATA
docker   Elasticsearch  
aigc
aigc   chatgpt  
WEB开发
linux   MongoDB   Redis   DATABASE   NGINX   其他Web框架   web工具   zookeeper   tornado   NoSql   Bootstrap   js   peewee   Git   bottle   IE   MQ   Jquery  
机器学习
机器学习算法  
Python88.com
反馈   公告   社区推广  
产品
短视频  
印度
印度  
Py学习  »  Python

python列表只打印到csv中的一行

Ferron12 • 5 年前 • 1317 次点击  

我希望将列表打印到每个列和行中。当它打印时,所有数据都被塞进一行csv文件中。我应该为csv文件做一个循环来逐个添加列表项吗?

def write_output(data):
    with open('data.csv', mode='w') as output_file:
        writer = csv.writer(output_file, delimiter=',', quotechar='"', quoting=csv.QUOTE_ALL)

        # Header
        writer.writerow(["locator_domain", "location_name", "street_address", "city", "state", "zip", "country_code",
                         "store_number", "phone", "location_type", "latitude", "longitude", "hours_of_operation"])
        # Body
        for row in data:
            writer.writerow(row)


def fetch_data():
    base_url = 'http://leevers.com/'
    r = requests.get(base_url)
    soup = BeautifulSoup(r.text, 'lxml')
    return_main_object = []
    n = soup.select('div > p:nth-of-type(1)')
    name = [a.text for a in n]
    a = soup.select('div > p:nth-of-type(2)')
    address = [a.text for a in a]
    c = soup.select('div > p:nth-of-type(3)')
    city = [a.text for a in c]
    p = soup.select('div > p:nth-of-type(4)')
    phone = [a.text for a in p]
    country_code = 'US'
    store = []
    store.append(base_url)
    store.append(name)
    store.append(address)
    store.append(city)
    store.append('<MISSING>')
    store.append('<MISSING>')
    store.append(country_code)
    store.append('<MISSING>')
    store.append(phone)
    store.append('<MISSING>')
    store.append('<MISSING>')
    store.append('<MISSING>')
    store.append('<MISSING>')
    return_main_object.append(store)
    return return_main_object
Python社区是高质量的Python/Django开发社区
本文地址:http://www.python88.com/topic/38922
 
1317 次点击  
文章 [ 1 ]  |  最新文章 5 年前