打开文章andCSV py

来源:互联网 发布:360mac版怎么样 编辑:程序博客网 时间:2024/06/03 19:44

一维

fo = open("price2017bj.csv", "w")ls = ['北京','101.5','120.1','121.4']fo.write(",".join(ls)+"\n")fo.close()#这段代码会自己创建一个表格,并将ls的内容输入表格中

那如果一行数据无法满足呢
那就写个二维吧

fo = open("price2017bj.csv", "w")ls = [['北京','101.5','120.1','121.4'],['上海','101.5','120.1','121.4']]for row in ls:  ###来个for循环就ok了    fo.write(",".join(row)+"\n")for i in range(len(ls)): ###第二种for方法    fo.write(",".join(ls[i])+"\n")fo.close()#注意如果fo.close()的()你整没了。那么...你的表里就什么都没有了
#fo=open("price.csv","r")fw=open("priceout.csv","w")ls=[]for line in fo:    line = line.replace("\n","")    ls.append(line.split(","))fo.close()for i in range(len(ls)):    for j in range(len(ls[i])):        if ls[i][j].replace(".","").isnumeric():            ls[i][j]="{:.2}".format(float(ls[i][j])/100)for row in ls:    fw.write(",".join(row)+"\n")fw.close()

打开文本中的内容

fname = input("open the txt:")fo = open(fname,"w+")ls=["你还好吗"]  #这个列表里写什么打开就是是什么。并不会因txt内容改变而变动fo.writelines(ls)fo.seek(0)###这个少了,就打不开了for line in fo:    print(line)

打开csv列表

fo=open("price.csv","r")ls=[]for line in fo:    line=line.replace("\n","")    ls.append(line.split(","))print(ls)fo.close()