python 提取csv内容脚本

目录

• python 提取csv内容脚本

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()