Jobs数量地区分布图
# +------+-----------+
# | area | Job数量 |
# +------+-----------+
# | 1 | 424 | 北京
# | 2 | 291 | 上海
# | 3 | 73 | 广州
# | 4 | 46 | 深圳
# | 5 | 62 | 杭州
# | 6 | 45 | 成都
# | 7 | 39 | remote
# | 8 | 127 | others
# +------+-----------+
点赞最多的 Topic
https://ruby-china.org//topics/13680
给薄荷网赞一个!
下面是主要程序片段
desc "获取ruby-china.org上的工作"
task :get_jobs => :environment do
time_start = Time.now
Job.connection
(1..74).each do |_id|
url = "https://ruby-china.org/jobs?page=#{_id}"
doc = Nokogiri::HTML(open(url))
doc.xpath("//div[@class='topics']/div").each do |_line|
topic_class = _line['class']
right_info_path = "//div[@class='#{topic_class}']/div[@class='right-info']"
topic_path = right_info_path +"/div[@class='pull-right replies']/a"
# 获取点赞数量
up = doc.xpath(topic_path).text
up = 0 if up.empty?
# 获取标题
title_path = right_info_path + "/div[@class='infos']/div[@class='title']/a"
title = doc.xpath(title_path)[0]['title']
# 获取url
url_suffix = doc.xpath(title_path)[0]['href']
url = "https://ruby-china.org/#{url_suffix}"
area = cal_area(title)
job = Job.create!(title: title, area: area, up: up, url: url)
puts "#{title}"
end
end
time_end = Time.now
puts "rake 执行完毕！耗时#{ time_end - time_start }秒"
end
Top 20
mysql> select title, up, url from jobs order by up desc limit 20\G;
*************************** 1. row ***************************
title: [上海]薄荷科技寻找靠谱的 Rubyist
up: 125
url: https://ruby-china.org//topics/13680
*************************** 2. row ***************************
title: [广州] 招聘 Ruby 程序员【已结束】
up: 124
url: https://ruby-china.org//topics/14975
*************************** 3. row ***************************
title: [西安] 途途科技招聘 Ruby/Rails 工程师 / 实习生
up: 111
url: https://ruby-china.org//topics/18818
*************************** 4. row ***************************
title: [北京] 酷传招聘Ruby on Rails全职实习生/初级工程师，当然我们也喜欢高手
up: 106
url: https://ruby-china.org//topics/5112
*************************** 5. row ***************************
title: [上海][浦东][扩招]一名 Ruby 工程师（附靓照）【已结束】
up: 102
url: https://ruby-china.org//topics/12391
*************************** 6. row ***************************
title: [北京] 天际网寻觅初、中、高级 Rubyist [暂停招聘]
up: 95
url: https://ruby-china.org//topics/5745
*************************** 7. row ***************************
title: [南京]暴走漫画招聘 rails 程序员(内有无节操图，慎入)
up: 94
url: https://ruby-china.org//topics/12431
*************************** 8. row ***************************
title: [日本] 宣传下我现在就职的公司：日本COOKPAD
up: 90
url: https://ruby-china.org//topics/864
*************************** 9. row ***************************
title: [深圳] Knewone.com 招聘 Ruby/Javascript/iOS 程序员
up: 90
url: https://ruby-china.org//topics/11561
*************************** 10. row ***************************
title: [北京][上海][远程] Doorder 招聘 Ruby on Rails 高级开发工程师
up: 89
url: https://ruby-china.org//topics/19290
*************************** 11. row ***************************
title: [上海] 百度诚招高级研发工程师 Ruby
up: 89
url: https://ruby-china.org//topics/15393
*************************** 12. row ***************************
title: [北京] 招靠谱 Ruby 攻城狮
up: 83
url: https://ruby-china.org//topics/3867
*************************** 13. row ***************************
title: [上海] "英语流利说"诚聘 Rails 开发工程师
up: 80
url: https://ruby-china.org//topics/12746
*************************** 14. row ***************************
title: 此贴复活！[杭州] 急招 Ruby 工程师，前端工程师，iOS，安卓，产品经理，月薪 10k-25k,办公地点可以自选.
up: 77
url: https://ruby-china.org//topics/15650
*************************** 15. row ***************************
title: [已结束][上海] 掌誉网络科技招聘靠谱Ruby程序员 - 你看了以后可能几天都睡不好觉的招聘帖
up: 76
url: https://ruby-china.org//topics/8893
*************************** 16. row ***************************
title: [深圳] KnewOne 招聘开发实习生（北京也招聘前后端开发）
up: 75
url: https://ruby-china.org//topics/17881
*************************** 17. row ***************************
title: [欧洲] Chinese speaker Ruby/JS/Web Developer - 招聘已结束
up: 75
url: https://ruby-china.org//topics/12750
*************************** 18. row ***************************
title: [杭州] The Plant 招人
up: 71
url: https://ruby-china.org//topics/2391
*************************** 19. row ***************************
title: [杭州滨江] 急招 Ruby 大神？高手？长者？
up: 68
url: https://ruby-china.org//topics/17351
*************************** 20. row ***************************
title: [广州] 招聘 Ruby / Rails 程序员
up: 67
url: https://ruby-china.org//topics/4337
20 rows in set (0.00 sec)
附加：PM2.5 对比
北京 vs 上海
北京 vs 广州
北京 vs 杭州
北京 vs 深圳
个人爱好，不喜勿喷。
宣传语
历经两个半月的准备，三次大改版，十七次小改版。le1024终于要和大家见面了。
le1024每天推荐1~3段，有趣、有爱、有故事的视频。
为您工作、学习、生活之余增加一点快乐的感觉。
网友评论
def cal_area(title)
if title.present?
return 1 if title.include?("北京")
return 2 if title.include?("上海")
return 3 if title.include?("广州")
return 4 if title.include?("深圳")
return 5 if title.include?("杭州")
return 6 if title.include?("成都")
return 7 if title.include?("remote") || title.include?("远程") || title.include?("Remote")
end
return 8
end