# How to get average salary for each experience level for each job title?

**URL:** <https://discourse.julialang.org/t/how-to-get-average-salary-for-each-experience-level-for-each-job-title/91003>\
**Category:** Performance\
**Tags:** question, inmemorydatasets\
**Created:** [November 29, 2022, 3:23pm UTC](https://discourse.julialang.org/t/how-to-get-average-salary-for-each-experience-level-for-each-job-title/91003 "2022-11-29T15:23:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![akshdfyehd](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/akshdfyehd/32/39097_2.png) [@akshdfyehd](https://discourse.julialang.org/u/akshdfyehd)\
**Post date:** [November 29, 2022, 3:23pm UTC](https://discourse.julialang.org/t/how-to-get-average-salary-for-each-experience-level-for-each-job-title/91003/1 "2022-11-29T15:23:53Z")

</div>

Hi, I got the dataset like following:

 ![1669735165297](https://global.discourse-cdn.com/julialang/original/3X/d/7/d731846ff75636820bc126bd1981d8159a1e49b6.png)  
I would like to get average salary for each experience level in each job title, I have tried:

```julia
 second=combine(groupby(new,:experience_level,),:salary_in_usd =>IMD.mean)

```

but then I realized if I do the leftjoin here it will be same salary for all experience level in different job title, my goal is to get a dataset where each experience level have average salary in each job title,does anyone knows how to do that?  
Thanks

---

<div class="post-metadata">

**Author:** ![nilshg](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nilshg/32/2283_2.png) [@nilshg](https://discourse.julialang.org/u/nilshg)\
**Post date:** [November 29, 2022, 5:52pm UTC](https://discourse.julialang.org/t/how-to-get-average-salary-for-each-experience-level-for-each-job-title/91003/2 "2022-11-29T17:52:57Z")

</div>

Please cross reference questions when posting to multiple sites - this was answered on stackoverflow already.