- 博客(8)
- 资源 (1)
- 收藏
- 关注
原创 python爬虫,链家
# -*- coding: utf-8 -*-"""Spyder EditorThis is a temporary script file."""import jsonimport requestsfrom requests.exceptions import RequestExceptionimport reimport timeimport pymysqlimpo...
2018-08-27 10:59:35 315
原创 python转化utf-8格式
response = urllib.request.urlopen('https://m.yimishiji.com/cat/22')web1 = response.read().decode('utf-8')print (web1)web = eval(repr(web1.replace(r'\\u',r"\u")).replace('\\\\', '\\')) #转化编码格式print...
2018-08-20 16:41:28 6328
原创 决策树
library(grid)library(mvtnorm)library(modeltools)library(stats4)library(strucchange)library(zoo)library(party)mydata <- readingSkills #将readingSkills数据存储在mydata里头names(mydata) #查看mydata中有几个...
2018-07-19 14:57:36 154
原创 数据库导入汉语文件
#导入数据create table 表1 like 表2;ALTER TABLE 16_nian CONVERT TO CHARACTER SET gbk COLLATE gbk_chinese_ci;load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/WORKs.csv' into table 16_nianchara...
2018-02-28 09:24:35 148
原创 mysql导入中文
ALTER TABLE nian_16 CONVERT TO CHARACTER SET gbk COLLATE gbk_chinese_ci;load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/wokek.csv' into table nian_16character set gbkfields terminated ...
2018-02-09 10:05:52 259
原创 16年二手交易金额时间序列
library(RMySQL)connect host = 'localhost', user = 'root', password = '123456', dbname = 'ninashuju')# 只需给
2018-01-16 16:41:59 190
原创 提取地址
select if(LOCATE('弄',房屋地址)>0,left(房屋地址,LOCATE('弄',房屋地址)),left(房屋地址,LOCATE('村',房屋地址))) as 提取 from 16nian;select 房屋地址,(casewhen LOCATE('支弄',房屋地址)>0 then left(房屋地址,LOCATE('支弄',房屋地址)+1) whe
2018-01-15 11:00:00 339
原创 删除空白单元格行
方法一Sub 删除空白单元格行() Dim num n_sum = Application.CountA(Range("b:b")) Do Until num > n_sum - 1 num = num + 1 If Cells(num, "b") = "" Then Cells(num, "
2018-01-13 15:40:37 305
tableau公式大全
2018-10-30
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人