jython 连接到 csv 文件

发布于 2024-10-18 12:27:34 字数 241 浏览 2 评论 0原文

你好我有一个读取 csv 文件的代码

import csv
d = csv.reader(open('C:/Documents and Settings/242481/My Documents/file.csv'))
for row in d:
    print row

此代码返回 csv 文件中的所有行有什么方法可以一次读取一行。每次执行打印行时，我都需要获取下一行。提前致谢阿迪斯

原文

Hi
I have a code to read the csv file

import csv
d = csv.reader(open('C:/Documents and Settings/242481/My Documents/file.csv'))
for row in d:
    print row

This code returns all the rows in the csv file
Is there any way i can read one row at a time.
And each time i execute the print line i need to get the next row.
Thanks in advance
Aadith

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

妄司 2024-10-25 12:27:34

它应该按照您的方式工作，但也许 EOL 字符不是您所使用的系统所期望的。尝试用 'rU' 打开它： open('file.csv', 'rU')

来验证它是否一次打印一行，您可以在行之间打印一个空行：


for row in d:
 print row
 print

或暂停它：

for row in d:
 print row
 raw_input('continue-> ')

对于您的其他代码，它应该是这样的：


def value():
 infile=open("C:/Documents and Settings/242481/My Documents/file.csv", "rU")
 data = [row for row in infile]
 infile.close()
 return data

始终关闭打开的文件。这是一个很好的做法，尽管并不总是严格必要的。 'file' 是一个 Python 类名。尽管您可以按照自己的意愿使用它们，但这样做可能会导致以后难以发现错误。

it should work the way you have it, but maybe the EOL characters are not what is expected for the system you're on. try opening it with 'rU': open('file.csv', 'rU')

to verify that it's printing one row at a time, you could print a blank line between rows:


for row in d:
 print row
 print

or pause it:

for row in d:
 print row
 raw_input('continue-> ')

For your other code, it should be something like:


def value():
 infile=open("C:/Documents and Settings/242481/My Documents/file.csv", "rU")
 data = [row for row in infile]
 infile.close()
 return data

Always close your open files. It's good practice, even though not always strictly necessary. And 'file' is a Python class name. Although you can use these any way you wish, doing so can lead to hard-to-find bugs later on.

回复收藏 0 原文

~没有更多了~