Python中PyMySQL提示AttributeError: module 'socket' has no attribute 'AF_UNIX'

2017-09-11 07:38:14 991 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

分位数回归和stata 分位数回归与stata 找了半天也没找到我想看的那种完整点的stata教程，只好自己写一个了… 参考教材：《用STATA学微观计量经济学》&《高级计量经济学及STATA应用_第2版》第一部分纯理论更加详细的百度吧，很长很长，这里主要是拿来和ols比较。ols是均值回归，求解的方法是残差的平方最小，而这里就是对残差的绝对值用分位数做惩罚。（思想了解一下即可）第二部分 Stata... 阅读详情

代码如下：
from urllib.request import urlopen
from bs4 import BeautifulSoup
import re
import datetime
import random
import pymysql

conn = pymysql.connect(host='127.0.0.1', unix_socket='/tmp/mysql.sock',
user='root', passwd=None, db='mysql', charset='utf8')
cur = conn.cursor()
cur.execute("USE scraping")

random.seed(datetime.datetime.now())

def store(title, content):
cur.execute("INSERT INTO pages (title, content) VALUES (\"%s\",\
\"%s\")", (title, content))
cur.connection.commit()

def getLinks(articleUrl):
html = urlopen("http://en.wikipedia.org"+articleUrl)
bsObj = BeautifulSoup(html)
title = bsObj.find("h1").get_text()
content = bsObj.find("div", {"id":"mw-content-text"}).find("p").get_text()
store(title, content)
return bsObj.find("div", {"id":"bodyContent"}).findAll("a",
href=re.compile("^(/wiki/)((?!:).)*$"))
links = getLinks("/wiki/Kevin_Bacon")
try:
while len(links) > 0:
newArticle = links[random.randint(0, len(links)-1)].attrs["href"]
print(newArticle)
links = getLinks(newArticle)
finally:
cur.close()
conn.close()

编译后提示错误：
Traceback (most recent call last):
File "F:\爬虫\17-9-11.py", line 9, in <module>
user='root', passwd=None, db='mysql', charset='utf8')
File "F:\Python 3.6\lib\site-packages\pymysql\__init__.py", line 90, in Connect
return Connection(*args, **kwargs)
File "F:\Python 3.6\lib\site-packages\pymysql\connections.py", line 706, in __init__
self.connect()
File "F:\Python 3.6\lib\site-packages\pymysql\connections.py", line 903, in connect
sock = socket.socket(socket.AF_UNIX, socket.SOCK_STREAM)
AttributeError: module 'socket' has no attribute 'AF_UNIX'

...全文