循环到CSV，导致python的行不平坦

Question

仍在学习Python，如果这是一个非常明显的错误，则很抱歉。不过，我一直在尝试弄清楚它几个小时，并认为我会看看是否有人可以提供帮助。

我已经刮了一个曲棍球网站的冰滑冰名称和价格，并将其写给了CSV。唯一的问题是，当我将其写入CSV时，“名称列的行”（列出为齿轮）和价格列未对齐。它进行：

• Gear Name 1
• 行太空
• 价格
• 行空间
• 齿轮名称2，

将齿轮和价格排相邻对齐是很棒的。如果有帮助，我也附上了与CSV图片的链接。

import requests
from bs4 import BeautifulSoup as Soup

webpage_response = requests.get('https://www.purehockey.com/c/ice-hockey-skates-senior?')

webpage = (webpage_response.content)
parser = Soup(webpage, 'html.parser')


filename = "gear.csv"
f = open(filename, "w")

headers = "Gear, Price"
f.write(headers)

for gear in parser.find_all("div", {"class": "details"}):
    
    gearname = gear.find_all("div", {"class": "name"}, "a")
    gearnametext = gearname[0].text
    
    gearprice = gear.find_all("div", {"class": "price"}, "a")
    gearpricetext = gearprice[0].text

    print (gearnametext)
    print (gearpricetext)

    f.write(gearnametext + "," + gearpricetext)

[排行不平的样子] [1] [1]：https：//i.sstatic.net/eg2f2.png

Answer 1

建议使用Python 3建议使用与open（fileName，'w'）作为f： and strip（）您的文本 write> write> write（）到您的文件。

除非您不使用“ A”模式来附加每行，否则您必须在编写的每一行中添加线路破解。

示例

import requests
from bs4 import BeautifulSoup as Soup

webpage_response = requests.get('https://www.purehockey.com/c/ice-hockey-skates-senior?')

webpage = (webpage_response.content)
parser = Soup(webpage, 'html.parser')


filename = "gear1.csv"
headers = "Gear,Price\n"


with open(filename, 'w') as f:
    f.write(headers)

    for gear in parser.find_all("div", {"class": "details"}):
        gearnametext = gear.find("div", {"class": "name"}).text.strip()
        gearpricetext = gear.find("div", {"class": "price"}).text.strip()
        f.write(gearnametext + "," + gearpricetext+"\n")

输出

Gear,Price
Bauer Vapor X3.7 Ice Hockey Skates - Senior,$249.99
Bauer X-LP Ice Hockey Skates - Senior,$119.99
Bauer Vapor Hyperlite Ice Hockey Skates - Senior,$999.98 - $1149.98
CCM Jetspeed FT475 Ice Hockey Skates - Senior,$249.99
Bauer X-LP Ice Hockey Skates - Intermediate,$109.99

...

Answer 2

我注意到gearnametext在字符串中返回2 \ n。您应该尝试方法str.replace（）删除正在创建跳到下一行的\ n。尝试：

import requests
from bs4 import BeautifulSoup as Soup

webpage_response = requests.get('https://www.purehockey.com/c/ice-hockey-skates-senior?')

webpage = (webpage_response.content)
parser = Soup(webpage, 'html.parser')


filename = "gear.csv"
f = open(filename, "w")

headers = "Gear, Price"
f.write(headers)

for gear in parser.find_all("div", {"class": "details"}):
    
    gearname = gear.find_all("div", {"class": "name"}, "a")
    gearnametext = gearname[0].text.replace('\n','')

    gearprice = gear.find_all("div", {"class": "price"}, "a")
    gearpricetext = gearprice[0].text

    print (gearnametext)
    print (gearpricetext)

    f.write(gearnametext + "," + gearpricetext)

我在循环内更改了：GearNametext = GearName [0] .Text.Replace（'\ n'，'，''）。