如何按年统计分组的负值

SELECT YEAR(transaction_date) AS year, COUNT(*) AS negative_count
FROM transactions
WHERE amount < 0
GROUP BY YEAR(transaction_date);

import pandas as pd

# 假设df是你的DataFrame，'date'是日期列，'value'是数值列
df['year'] = df['date'].dt.year  # 提取年份
negative_counts_by_year = df[df['value'] < 0].groupby('year').size()

const data = [
  // 假设每个元素是一个对象，包含date和value属性
];

const negativeCountsByYear = data
  .filter(item => item.value < 0)
  .reduce((acc, item) => {
    const year = new Date(item.date).getFullYear();
    if (!acc[year]) acc[year] = 0;
    acc[year]++;
    return acc;
  }, {});

console.log(negativeCountsByYear);