需要在按不匹配日期分组的2个索引上转置一些SQL值(SQL和Python)

SELECT date_column, SUM(value_column) 
FROM your_table
GROUP BY date_column;

SELECT 
    date_column,
    SUM(CASE WHEN index_column = 'index1' THEN value_column END) AS index1,
    SUM(CASE WHEN index_column = 'index2' THEN value_column END) AS index2,
    ...
FROM (
    SELECT date_column, index_column, SUM(value_column) AS value_column
    FROM your_table
    GROUP BY date_column, index_column
) AS subquery
GROUP BY date_column;

import pandas as pd

data = {
    'date_column': ['2022-01-01', '2022-01-01', '2022-01-02', '2022-01-02'],
    'index_column': ['index1', 'index2', 'index1', 'index2'],
    'value_column': [10, 20, 30, 40]
}

df = pd.DataFrame(data)
result = df.groupby('date_column')['value_column'].sum()

result = result.reset_index().pivot(index='date_column', columns='index_column', values='value_column')