JavaScript的数据处理,需要处理成指定样式

[
 { '科室': '生产科', year: 2023, week: '01', '数量': 7 },
 { '科室': '综合组', year: 2023, week: '01', '数量': 6 },
 { '科室': '外科', year: 2023, week: '01', '数量': 2 },
 { '科室': '外科', year: 2022, week: '52', '数量': 11 },
 { '科室': '生产科', year: 2022, week: '52', '数量': 20 },
 { '科室': '综合组', year: 2022, week: '52', '数量': 10 },
 { '科室': '测量科', year: 2022, week: '52', '数量': 1 },
 { '科室': '综合组', year: 2022, week: '51', '数量': 14 },
 { '科室': '外科', year: 2022, week: '51', '数量': 9 },
 { '科室': '生产科', year: 2022, week: '51', '数量': 15 },
 { '科室': '生产科', year: 2022, week: '50', '数量': 2 },
 { '科室': '外科', year: 2022, week: '50', '数量': 1 }
]

基础数据如上所示

想将数据处理成如下所示:

'生产科':[7,20,15,2],
'外科':[2,11,9,1],
'综合组':['',1,'',''],
'测量科':[6.10.14.''],
'周':[’2023-KW01',"2022-KW52","2022-KW51","2022-KW50"]

数据不是写死的,不过 科室是固定的,就那4个
重点是 有的科室 在周没有数据,需要在相应位置填 "" 占位

img

let data = [
 { '科室': '生产科', year: 2023, week: '01', '数量': 7 },
 { '科室': '综合组', year: 2023, week: '01', '数量': 6 },
 { '科室': '外科', year: 2023, week: '01', '数量': 2 },
 { '科室': '外科', year: 2022, week: '52', '数量': 11 },
 { '科室': '生产科', year: 2022, week: '52', '数量': 20 },
 { '科室': '综合组', year: 2022, week: '52', '数量': 10 },
 { '科室': '测量科', year: 2022, week: '52', '数量': 1 },
 { '科室': '综合组', year: 2022, week: '51', '数量': 14 },
 { '科室': '外科', year: 2022, week: '51', '数量': 9 },
 { '科室': '生产科', year: 2022, week: '51', '数量': 15 },
 { '科室': '生产科', year: 2022, week: '50', '数量': 2 },
 { '科室': '外科', year: 2022, week: '50', '数量': 1 }
]
// 获取科室列表
let typeList = []
let date = []
let result = {}
data.forEach(item => {
  if (!typeList.includes(item['科室'])) {
    typeList.push(item['科室'])
    result[item['科室']] = []
  }
  let week = item.year + '-' + item.week
  if (!date.includes(week)) {
    date.push(week)
  }
})

Object.keys(result).forEach(key => {
    date.forEach((item, index) => {
        result[key][index] = ""
    })
    data.forEach(item => {
        if (key == item['科室']) {
            date.forEach((weekItem, index) => {
                if (item.year + "-" + item.week == weekItem) {
                    result[key][index] = item['数量']
                }
            })
        }
    })
})

result["周"] = date
console.log(JSON.stringify(result))

详细代码实现如下,望采纳

const data = [
 { '科室': '生产科', year: 2023, week: '01', '数量': 7 },
 { '科室': '综合组', year: 2023, week: '01', '数量': 6 },
 { '科室': '外科', year: 2023, week: '01', '数量': 2 },
 { '科室': '外科', year: 2022, week: '52', '数量': 11 },
 { '科室': '生产科', year: 2022, week: '52', '数量': 20 },
 { '科室': '综合组', year: 2022, week: '52', '数量': 10 },
 { '科室': '测量科', year: 2022, week: '52', '数量': 1 },
 { '科室': '综合组', year: 2022, week: '51', '数量': 14 },
 { '科室': '外科', year: 2022, week: '51', '数量': 9 },
 { '科室': '生产科', year: 2022, week: '51', '数量': 15 },
 { '科室': '生产科', year: 2022, week: '50', '数量': 2 },
 { '科室': '外科', year: 2022, week: '50', '数量': 1 }
];

const departmentData = {
  '生产科': [],
  '外科': [],
  '综合组': [],
  '测量科': []
};
const weeks = [];

data.forEach(item => {
  const department = item['科室'];
  departmentData[department].push(item['数量']);
  if (!weeks.includes(item.week)) {
    weeks.push(item.week);
  }
});

const processedData = {
  '生产科': departmentData['生产科'],
  '外科': departmentData['外科'],
  '综合组': departmentData['综合组'],
  '测量科': departmentData['测量科'],
  '周': weeks.map(week => {
    return `2022-KW${week}`;
  })
};

console.log(processedData);

这个是什么意思

img