English 中文(简体)
• 如何将 com马分离的数据与茨夫档案分开?
原标题:How to separate comma separated data from csv file?
  • 时间:2010-03-09 10:38:41
  •  标签:
  • python

我已经开立了一个小卷宗,我想对每一座str子进行分类,这些str子是分开的,其行文相同:

页: 1

name,sal,dept
tom,10000,it

o/p 缩略语

我有一份已经公开的文件,因此我不能使用“开放”的预报器,我必须使用“快乐器”,而“快乐器”必须随时读到一条线。

问题回答

开放阅读的档案如果受一个变数名称的约束,即fin;假设你重新使用< 2.6”,则你知道档案不是空的(至少是头盔一行):

 import csv

 rd = csv.reader(fin)
 headers = next(rd)
 for data in rd:
   ...process data and headers...

在A/63/12.5中,使用<代码>headers = rd.next()而不是headers = 下一个(rd)

这些版本使用一个领域清单<代码>/代码>,这是一个完整的一般解决办法(即,您无需事先了解档案中有多少栏目:作为<代码>、[0]、<编码>>>>、数据3.1等,而目前的行文有<代码>len(数据)各栏。

如果你知道档案有三栏,更倾向于使用每栏变量的单独名称,则会长改为:

 for name, sales, department in rd:

读者(如头盔人员)所交回的外地数据都是直线的。 如果你知道第二栏是隐蔽的,希望按此处理,就开始排行。

 for data in rd:
     data[1] = int(data[1])

或者,如果你重新使用点名变量:

 for name, sales, department in rd:
     sales = int(sales)

我不知道我是否正确理解你的问题。 请参看。 无论如何。





相关问题
Can Django models use MySQL functions?

Is there a way to force Django models to pass a field to a MySQL function every time the model data is read or loaded? To clarify what I mean in SQL, I want the Django model to produce something like ...

An enterprise scheduler for python (like quartz)

I am looking for an enterprise tasks scheduler for python, like quartz is for Java. Requirements: Persistent: if the process restarts or the machine restarts, then all the jobs must stay there and ...

How to remove unique, then duplicate dictionaries in a list?

Given the following list that contains some duplicate and some unique dictionaries, what is the best method to remove unique dictionaries first, then reduce the duplicate dictionaries to single ...

What is suggested seed value to use with random.seed()?

Simple enough question: I m using python random module to generate random integers. I want to know what is the suggested value to use with the random.seed() function? Currently I am letting this ...

How can I make the PyDev editor selectively ignore errors?

I m using PyDev under Eclipse to write some Jython code. I ve got numerous instances where I need to do something like this: import com.work.project.component.client.Interface.ISubInterface as ...

How do I profile `paster serve` s startup time?

Python s paster serve app.ini is taking longer than I would like to be ready for the first request. I know how to profile requests with middleware, but how do I profile the initialization time? I ...

Pragmatically adding give-aways/freebies to an online store

Our business currently has an online store and recently we ve been offering free specials to our customers. Right now, we simply display the special and give the buyer a notice stating we will add the ...

Converting Dictionary to List? [duplicate]

I m trying to convert a Python dictionary into a Python list, in order to perform some calculations. #My dictionary dict = {} dict[ Capital ]="London" dict[ Food ]="Fish&Chips" dict[ 2012 ]="...

热门标签