利用python 模块读取csv文件信息

还有一个比较简单的方法

# -*- coding=utf-8 -*-

import pandas as pd
df = pd.read_csv("20170320094630.csv",encoding="gb2312")
print("df is \n",df)
标黄的地方,切记,切记

 

 

 

import unicodecsv

enrollments_filename = '/datasets/ud170/udacity-students/enrollments.csv'

## Longer version of code (replaced with shorter, equivalent version below)

# enrollments = []
# f = open(enrollments_filename, 'rb')
# reader = unicodecsv.DictReader(f)
# for row in reader:
# enrollments.append(row)
# f.close()

with open(enrollments_filename, 'rb') as f:
reader = unicodecsv.DictReader(f)
enrollments = list(reader)

### Write code similar to the above to load the engagement
### and submission data. The data is stored in files with
### the given filenames. Then print the first row of each
### table to make sure that your code works. You can use the
### "Test Run" button to see the output of your code.

engagement_filename = '/datasets/ud170/udacity-students/daily_engagement.csv'
submissions_filename = '/datasets/ud170/udacity-students/project_submissions.csv'
def read_csv(filename):
with open(filename,'rb') as f:
reader = unicodecsv.DictReader(f)
return list(reader)

daily_engagement = read_csv(engagement_filename) # Replace this with your code
print daily_engagement[0]
project_submissions = read_csv(submissions_filename) # Replace this with your code
print project_submissions[0]

转载于:https://www.cnblogs.com/wutongyuhou/p/6858785.html

使用Pythoncsv模块可以很方便地读取CSV文件。首先,你需要确保你已经关闭了正在使用的CSV文件。然后,你可以按照以下步骤来读取CSV文件: 1. 首先,导入csv模块:`import csv` 2. 打开CSV文件并创建一个文件对象:`file = open('filename.csv', 'r')` 3. 通过csv模块的reader函数创建一个reader对象:`reader = csv.reader(file)` 4. 使用for循环遍历reader对象,逐行读取CSV文件的内容:`for row in reader:` 5. 在循环中,可以通过索引访问每一列的值,例如`row`代表第一列的值。 下面是一个示例代码,演示了如何使用csv模块读取CSV文件: ``` import csv # 打开CSV文件并创建一个文件对象 file = open('filename.csv', 'r') # 通过csv模块的reader函数创建一个reader对象 reader = csv.reader(file) # 使用for循环遍历reader对象,逐行读取CSV文件的内容 for row in reader: # 在循环中,可以通过索引访问每一列的值 print(row<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *2* *3* [使用python自带CSV模块读写csv文件](https://blog.csdn.net/qq_42215863/article/details/124358808)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 100%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值