我是Python新手，我想在CSV文件中对IP执行一些反向DNS查找。CSV有一个'ip'列，地址格式如下：
example of source input data
我的python脚本只适用于单个IP，但我不确定如何读取具有多个IP地址的行。

#pip install pandas
#pip install dnspython
#pip install xlrd, pip install xlsxwriter

### Import needed libraries ###
import pandas as pd
import time 

from pandas.io.excel import ExcelWriter
from dns import resolver,reversename

### Time variable ###
startTime = time.time()

#Custom Delimiter
custom_delimiter = ','
logs = pd.read_csv('C:\\Users\\user\\Desktop\\rdnslookup\\input_file\\logs.csv', sep=custom_delimiter, quotechar=',', engine='python', converters={'ip': lambda x:x.strip('["]')}, on_bad_lines = "skip") 

#Diagnostic print statement
print(logs.head)

# Create new Dataframe that removed duplicate IP addresses
logs_filtered = logs.drop_duplicates(['ip']).copy() 

### Perform DNS lookup on deduplicated IPs ###
def reverseDns(ip):
  try: 
    return str(resolver.query(reversename.from_address(ip), 'PTR')[0])
  except: 
    return 'N/A'

### Create DNS column with the reverse IP DNS result ###
logs_filtered['dns'] = logs_filtered['ip'].apply(reverseDns)

### Merge DNS column to full logs matching IP ###
logs_filtered = logs.merge(logs_filtered[['ip','dns']], how='left', on=['ip'])

### Output IP addresses to CSV with DNS lookups ###
writer = ExcelWriter('C:\\Users\\user\\Desktop\\rdnslookup\\output_file\\validated_logs.xlsx', engine='xlsxwriter',)
logs_filtered.to_excel(writer,'Sheet1', index=False)
writer.close()

字符串
我试着把引号改为““，但这并没有从多个地址的行中删除引号，感谢任何帮助。谢谢