目录
python 提取csv内容脚本
提取csv的内容脚本,这里只是提取了单个csv文件的内容,也没有写入新的文件,也没有把数据处理成json,临时模版,比较简陋,方便自己后面改动,记录下
#!/usr/bin/python3
import csv
iplist=[]
def ReadCsvFileFirst(iplist):
with open('./test.csv','r',encoding='utf-8-sig') as f:
reader = csv.reader(f)
for row in reader:
# 打印主机Ip
for hostip in row[0:1]:
if hostip == "主机名":
continue
else:
ListAdd(iplist,hostip)
# print(hostip,end="\t")
return iplist
def ListAdd(iplist,ip):
iplist.append(ip)
return iplist
def ChangeListoSet(iplist):
setlist=list(set(iplist))
return setlist
def GetInfoByIp():
with open('./test.csv','r',encoding='utf-8-sig') as f:
line = csv.reader(f)
for row in line:
for ip in FixIpList(iplist):
if ip in row[0:1]:
# print (str(row[5:6]) == str('renjianhua'))
# name1 = str((','.join(row[5:6])))
# name2 = str('renjianhua')
# print(type(name1),type(name2))
# print(name1 == name2)
if (str(','.join(row[5:6])) == "liuyazhou" or (','.join(row[5:6])) == "liubolun"):
continue
else:
print (','.join(row[1:2]),','.join(row[0:1]),','.join(row[5:6]),'123456!')
def FixIpList(iplist):
# 获取主机Ip列表信息
newiplist=ReadCsvFileFirst(iplist)
# 去重
iplist=ChangeListoSet(iplist)
return iplist
# 获取主机列表并去重
FixIpList(iplist)
# 根据ip地址打印ip所在行的Ip,账号,固定密码
GetInfoByIp()
标签:提取,join,python,ip,print,iplist,csv,row
From: https://www.cnblogs.com/liwenchao1995/p/17203088.html