利用Python进行数据分析-第六章

读写文本格式的数据

class my_dialect(csv.Dialect):
    lineterminator = '\n'
    delimiter = '；'
    quotechar = '"'
---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
C:\Users\lingfang\desktop\<ipython-input-30-c6a3e215af39> in <module>()
      1 with open('mydata.csv','w') as f:
----> 2     writer = csv.writer(f,dialect = my_dialect)
      3     writer.writerow(('one','two','three'))
      4     writer.writerow(('1','1','1'))
      5     writer.writerow(('12','13','14'))

TypeError: "quoting" must be an integer


#定义一个自己的分割格式
class my_dialect(csv.Dialect):
    lineterminator = '\n'
    delimiter = '；'
    quotechar = '"'
    quoting = 0 #按照书本中的代码会报错

with open('mydata.csv','w') as f:
    writer = csv.writer(f,dialect = my_dialect)
    writer.writerow(('one','two','three'))
    writer.writerow(('1','1','1'))
    writer.writerow(('12','13','14'))

效果：
one；two；three
1；1；1
12；13；14

Json数据

import json
result = json.loads(json对象)
#result就变为python对象

asjson = json.dumps(result)
#将python对象变为json对象

Web信息收集

from lxml.html import parse
---------------------------------------------------------------------------
ImportError                               Traceback (most recent call last)
C:\Users\lingfang\<ipython-input-6-70a1d2288297> in <module>()
----> 1 from lxml.html import parse

ImportError: No module named lxml.html

安装lxml模块

https://www.lfd.uci.edu/~gohlke/pythonlibs/#lxml
找到对应的版本的对应安装包
这是我的对应版本lxml‑4.2.4‑cp27‑cp27m‑win32.whl
下载好之后cmd进入该安装包的路径下
根据命令 pip install lxml‑4.2.4‑cp27‑cp27m‑win32.whl

再进行Import就不会报错了！