我需要我的csv输出使用逗号而不是分号,这样我就可以插入到我的sqlite数据库

2024-03-29 04:44:46 发布

您现在位置:Python中文网/ 问答频道 /正文

现在我的nmap csv正在文件中放分号,我需要把它改成逗号

nmap扫描

import first
import csv
import nmap
csvFilePath = "nmapscan1.csv"
ipAddress = first.ipAddress
port = first.port

#nmap scan using user input varibles
nm = nmap.PortScanner()

nm.scan(ipAddress,port)

csv = nm.csv()
print(csv)

#writing to csv file
with open(csvFilePath, "w") as csvFile:
    csvFile.write(csv)
#changes ; to , for database use
with open(r"nmapscan1.csv") as in_file, open(r"nmapscan.csv", 'w') as 
out_file:
    semicolonin = csv.reader(in_file, delimiter=';')
    commaout = csv.writer(out_file, delimiter=',')
    for row in semicolonin:
        commaout.writerow(row)

在Ubuntu终端中出错

Traceback (most recent call last):
  File "second.py", line 23, in <module>
    semicolonin = csv.reader(in_file, delimiter=';')
AttributeError: '_io.TextIOWrapper' object has no attribute 'reader'

Tags: csvinimportportasopennmapreader