python - 如何消除 CSV 文件中的空白？

Question

这个问题已经有答案了:

CSV file written with Python has blank lines between each row (11 个回答)

已关闭 6 年前。

当我运行程序时，在空白 CSV 文件中，每个产品之间似乎有一行间隙。如何消除这个差距？ (如第一张图所示)

This is what happens when I fully run my code

This is my original CSV file that contains all the product information. Row A is the GTIN-8 code, row B is the product name, C is the current stock level, D is the re-order stock level, and E is the target stock level (Just to clarify)

这是我的代码:

import csv
redo='yes'

receipt=open('receipt.txt', 'wt')

stock=open('Stock_.csv', 'rt')
stock_read=csv.reader(stock)

blank_csv=open('Blank_csv_.csv', 'wt')
blank_csv_write=csv.writer(blank_csv)


clothes=(input('\nPlease enter the GTIN-8 code of what you want to purchase: '))
quantity=int(input('\nPlease enter the amount of this product you want to buy: '))

for row in stock_read:
    GTIN=row[0]
    product=row[1]
    current=row[2]
    re_order=row[3]
    target=row[4]

    if clothes==GTIN:
        current=int(current)-quantity
    blank_csv_write.writerows([[GTIN,product,current,re_order,target]])

stock.close()
blank_csv.close()

reorder_receipt=open('receipt.txt', 'wt')

blank_csv2=open('Blank_csv_.csv', 'rt')
blank_csv_read2=csv.reader(blank_csv2)

stock_check=input('Press \"ENTER\" if you want to check the current stock leavels: ')

if stock_check=='':
    for row in blank_csv_read2:
        for field in row:

            GTIN=row[0] 
            product=row[1]
            current=int(row[2])
            re_order=int(row[3])
            target=int(row[4])
            if current<=re_order:
                re_stock=target-current
                reorder_receipt.write(GTIN+' '+product+' '+str(current)+' '+str(re_order)+' '+str(target)+' '+str(re_stock)+'\n')

blank_csv2.close()
reorder_receipt.close()

先谢谢你了!!!!

Answer 1

这似乎是 THIS 的重复项问题。我相信那里的答案将帮助您解决您的问题。提示:换行符=''