Skip to content

一、通用代码

一、数据去重

1、时间去重

python
const allDate=[]
    data.value.forEach(item=>{
        let time=item.dateTime.split(" ")[0]
        if(!allDate.includes(time)) allDate.push(time) 
    })
    const sortedDate = allDate.sort((a,b)=>new Date(a)-new Date(b))

二、数据转换

1、

js
const res=data.value.map(item=>{
        return {
            name:item.serviceType,
            value:item.userId
        }
    })

2、过滤年份,过滤月份

js
const data = this.res.filter(item => {
     let time = item.date1.split("/")[0]
     return time === this.op
   }).sort((a, b) => new Date(a.date1) - new Date(b.date1))

   const month = []
   data.forEach(item => {
     let time = item.date1.split("/")[1]
     if (!month.includes(time)) month.push(time)
   })
   const result = month.map(item => {
     let volume = 0
     let count = 0
     data.forEach(item2 => {
       let time = +(item2.date1.split("/")[1])
       if (time === +item) {
         volume += item2.volume
         count++
       }
     })
     return {
       name: item,
       value: 
         +((volume / count).toFixed(2))
     }
   })