- 博客(4)
- 收藏
- 关注
原创 几个sql语句
select count(distinct(company_name)) from bj_capital 60/69select count(distinct(company_name)) from bj_capital2 134/193SELECT company_name FROM bj_capital UNION SELECT company_name FROM bj_
2016-12-06 17:45:38 308
原创 提取文章高频词
# -*- coding: utf-8 -*-# * @author haoming# * @date 2016/11/08import MySQLdbimport pandas as pdimport numpy as npimport reimport codecs import jiebaimport jieba.analyseimport loggingfrom gens
2016-12-06 12:47:44 5827
原创 python 写入csv防止乱码
# coding: utf-8import codecsimport osos.chdir("F:\project\predict")import csvcsvfile = open('csv_test.csv', 'wb')csvfile.write(codecs.BOM_UTF8) #防止乱码writer = csv.writer(csvfile)writer.writerow(['姓
2016-12-05 18:44:35 3989 5
原创 根据两个已有表建立新表
create table clue.dust as SELECT distinct c.company_name,c.reg_no, c.city, c.bus_scope, case when b.flag=1 then 1 else 0 end as new_flagFROM (select company_name, reg_no,city,bus_scope,province fro
2016-12-05 10:03:09 492
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人