从文件csv剥离空白 [英] strip white spaces from file csv

查看:149
本文介绍了从文件csv剥离空白的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我需要从读取的csv文件中划分空格。
import csv

  aList = [ ] 
with open(self.filename,'r')as f:
reader = csv.reader(f,delimiter =',',quoting = csv.QUOTE_NONE)
阅读器:
aList.append(row)
#i需要从行中的每个字符串中去除额外的空白
return(aList)

解决方案

还有嵌入格式化参数:skipinitialspace(默认为false)
http://docs.python.org/2/library/csv.html#csv -fmt-params

  aList = [] 
with open(self.filename,'r' )as f:
reader = csv.reader(f,skipinitialspace = False,delimiter =',',quoting = csv.QUOTE_NONE)
读取器中的行:
aList.append )
return(aList)


I need to stripe the white spaces from a csv file that i read import csv

aList=[]
with open(self.filename, 'r') as f:
    reader = csv.reader(f, delimiter=',', quoting=csv.QUOTE_NONE)
    for row in reader:
        aList.append(row)
    # i need to strip the extra white space from each string in the row
    return(aList)

解决方案

There's also the embedded formatting parameter: skipinitialspace (the default is false) http://docs.python.org/2/library/csv.html#csv-fmt-params

aList=[]
with open(self.filename, 'r') as f:
    reader = csv.reader(f, skipinitialspace=False,delimiter=',', quoting=csv.QUOTE_NONE)
    for row in reader:
        aList.append(row)
    return(aList)

这篇关于从文件csv剥离空白的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆