某招聘网站职位分析项目整理

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/DLhuahai/article/details/83548384

考察的知识点:Excel函数、图表、数据透视表

这是一份某求职网站上关于数据分析的数据

1、求每家公司的最高薪资和最低薪资以及平均薪资

最低工资:LEFT(D2,FIND("k",D2)-1)

最高工资:MID(D2,FIND("-",D2)+1,LEN(D2)-FIND("-",D2)-1)

平均工资:AVERAGE(G2*1,H2*1)

2、将职位包含数据分析、数据运营、分析师等的公司找出来

IF(COUNT(FIND({"数据分析","数据运营","分析师"},A2)),B2,FALSE)

3、获取每家公司对应的公司地址放到Sheet1表里显示出来

VLOOKUP(B2,Sheet2!$A$2:$B$100,2,FALSE)

4、得到一些具体数据:最低薪资大于15K的公司一共有多少家和最高薪资低于15K的公司一共有多少家

最低薪资大于15k的公司

最高薪资小于15k的公司

5、根据公司规模判断该公司属于大公司、中公司还是小公司(大于2000的为大公司,500到2000的为中公司,小于500的为小公司)

IF(F2="2000人以上","大公司",IF(F2="500-2000人","中公司","小公司"))

6、查看不同城市对求职者工作年限的规定的公司数量,可以通过数据透视表及图来展示

7、查看不同城市公司不同规模的个数,可以通过数据透视表及图来展示

8、查看不同城市大中小公司的个数,可以通过数据透视表及图来展示

9、查看不同城市的平均薪资,可以通过数据透视表及图来展示

10、查看不同城市不同年限的平均薪资,可以通过数据透视表及图来展示

 

展开阅读全文

Nvidia 职位招聘

01-23

Position Title: Devtech Engineer rnLocation: China rnrnJob Description/Qualifications: rnNVIDIA is searching for world-class software engineers for an exciting role in Developer Technology. Work with the most exciting high-performance computing applications, on cutting-edge computational systems, with developers throughout the world. Interact closely with the architecture and software teams at NVIDIA to ensure the best possible performance and results. Work to help influence the developer experience with current-generation hardware as well as determine trends and features for next-generation architectures. You will work with the latest GPU technology working with HPC, Visual Consumer, and Professional applications.rnFor HPC and Professional Applications, you will work on parallelizing software algorithms for applications in a variety of fields including geo-sciences, medicine, computational biology, and digital content creation tools.rnFor Visual Consumer applications, you will work with video, photo imaging, computer vision consumer applications. rnAn important part of this role will be to support, evangelize, and influence NVIDIA GPU in either graphics or general purpose computing technologies to developers. You will develop and implement new data-parallel algorithms and systems, create technical demos, write whitepapers and present your work at conferences. Through collaboration with external software developers, you will help to optimize their products using NVIDIA technology.rnrnMINIMUM REQUIREMENTS: rnSkills Required: rn- Strong knowledge of C/C++ and programming techniques rn- Strong mathematical fundamentals, including linear algebra and numerical methods. rn- Good communication skills required. rn- Travel for on-site visits with developers and to conferences will be required. rn- Ideal candidates will have experience with parallel programming, especially data-parallel and/or GPGPU. rn- Minimum 3 years of industry or academic experience (or equivalent) in a related field. rn- B.S. or higher degree in Computer Science/Engineering or mathematical field. rn- Experience with OpenMP, MPI, Fortran, and parallel programming is a plus rn- Experience with CUDA, DirectX, or OpenGL is a plus. rn- Experience in benchmarking a plus rn- Familiar with CPU System architecture and OS fundamentals. rn- A strong team player that is self motivated. rnrnfor job application, please send your resume to: sz-recruitment@nvidia.com: sz-recruitment@nvidia.comrnrn 论坛

没有更多推荐了,返回首页