matplotlib画四种图表的实例（没有太多注释，但python小白可以看懂）

本文中的数据用的是以前scrapy爬取的51job网站的数据，通过sql语句存到json文件中，进行数据处理和图像展示

matplotlib画四种图表的实例

python的matplotlib库很强大，可以画很多图，今天画的是其中的一小部分，点线图，柱状图，饼图，散点图。

sql语句（在数据库中有数据的前提下）

    def findPositionClassify(self):
        sql = "select avg(job_meansalary),job_taskid,task_title from job_position,job_collect_task where "+\
              "job_position.job_taskid = job_collect_task.task_id group by job_taskid,task_title"
        result = self.execute(sql,params=None)
        self.commit()
        return self.fetch()
        pass

    def findCityPositionClassify(self):
        sql = "select avg(t1.job_meansalary) as m,t1.job_taskid,t2.task_title,t1.job_city from "+\
                "job_position t1 left join job_collect_task t2 "+\
                "on t1.job_taskid = t2.task_id group by job_taskid,job_city,t2.task_title order by "+\
                "t1.job_taskid asc,m desc"
        result = self.execute(sql,params=None)
        self.commit()
        return self.fetch()
        pass
    def bingshuju(self):
        sql = "select avg(job_position.job_meansalary),job_city from job_position where job_taskid = '1' group by job_taskid,job_city order by avg(job_position.job_meansalary) desc;"
        result = self.execute(sql, params=None)
        self.commit()
        return self.fetch()
        pass
    def sandiantu(self):
        sql = "select job_taskid,job_city,avg(job_position.jo