# spider

**Repository Path**: arye/spider

## Basic Information

- **Project Name**: spider
- **Description**: 采集招聘网址数据并分析
https://blog.csdn.net/Yellow_python/article/details/80795881
记得点个赞
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 4
- **Forks**: 1
- **Created**: 2020-04-13
- **Last Updated**: 2022-07-13

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

https://blog.csdn.net/Yellow_python/article/details/80795881
记得点个赞

mysql自行建库建表

database
	z_test

SQL
	CREATE TABLE quanguo(
	url CHAR(255) PRIMARY KEY,
	name CHAR(255),
	salary CHAR(255),
	region CHAR(255),
	workplace CHAR(255),
	cp_name CHAR(255),
	cp_type CHAR(255),
	cp_scale CHAR(255),
	industry CHAR(255),
	exp CHAR(255),
	edu CHAR(255),
	demand CHAR(255),
	pubdate CHAR(255),
	skill CHAR(255),
	welfare CHAR(255),
	detail TEXT,
	kw CHAR(255) COMMENT '关键词',
	collect_date DATE COMMENT '采集日期'
	);


运行
    1、采集
    \qianchengwuyou\qianchengwuyou\z_run.py
    然后自行输入关键词
    2、分析
    \analysis\run.py
    输入相同关键词