迭代文件读取

Question

在Windows 10上使用Python 3.5.2 :：Anaconda 4.0.0 (64位)。

我有一个名为upgrade.csv的文件，它包含以下内容：

['$APPL','$FB','$MSLI','$AMZN','$NVDA','$WMT','$NFLX']

我想遍历每一个股票符号。

使用以下代码从文件中提取返回：

[
'
$
A
P
P
L
'
,
'
$
F
B
'
,

等等，通过数据。

第一码：

file = open('upgrades.csv', 'r')
upgrades = (file.read())
file.close()
upgrades = list(upgrades)
for i in range(len(upgrades)):
    print(upgrades[i])

从显式字符串中提取返回我想要的内容：

$APPL
$FB
$MSLI
$AMZN
$NVDA
$WMT
$NFLX

第二代码：

upgrades = ['$APPL','$FB','$MSLI','$AMZN','$NVDA','$WMT','$NFLX']
upgrades = list(upgrades)
for i in range(len(upgrades)):
    print(upgrades[i])

请帮助我从文件中提取数据，并得到以下结果：

$APPL
$FB
$MSLI
$AMZN
$NVDA
$WMT
$NFLX

我尝试过转换数据，例如：

upgrades = list(upgrades)
upgrades = str(upgrades)
upgrades = tuple(upgrades)

我还尝试将文件从csv更改为txt。

Answer 1

将其视为一个单行csv，并按以下方式进行。

with open('upgrades.csv', 'r') as upgrade:
    for line in upgrade.readlines():
        lines = line.split(",")
        for m in lines:print m

Answer 2

In[5]: import json
  ...: 
  ...: with open('upgrades.csv', 'r') as f:
  ...:     data = json.loads(f.read().replace("'", '"'))
  ...: 
  ...: print(data)
  ...: for item in data:
  ...:     print(item)
  ...: 
['$APPL', '$FB', '$MSLI', '$AMZN', '$NVDA', '$WMT', '$NFLX']
$APPL
$FB
$MSLI
$AMZN
$NVDA
$WMT
$NFLX

In[6]: from ast import literal_eval
  ...: 
  ...: with open('upgrades.csv', 'r') as f:
  ...:     data = literal_eval(f.read())
  ...: 
  ...: print(data)
  ...: for item in data:
  ...:     print(item)
  ...: 
['$APPL', '$FB', '$MSLI', '$AMZN', '$NVDA', '$WMT', '$NFLX']
$APPL
$FB
$MSLI
$AMZN
$NVDA
$WMT
$NFLX