具有不同切片的平均超过2d numpy阵列(Mean over 2d numpy array with varying slices)

 这里有一个类似的问题： 
 
 如何将ROW INDEX作为列添加到SQL SELECT查询？ 
 
 从这个问题扩展到你想要的东西： 
 
SET @row_num = 0;
SELECT
  T.id,T.name,T.status,IFNULL(T.image, 'no-image.png') AS DP,
  (SELECT COUNT(*) FROM badminton_matches MT WHERE (MT.team_one = T.id OR MT.team_two = T.id)) 
  AS played,
  (SELECT COUNT(*) FROM badminton_match_results R WHERE R.winner_id = T.id) AS won,
  (SELECT COUNT(*) FROM badminton_matches MT JOIN badminton_match_results MR 
    ON (MR.match_id = MT.id) 
    WHERE (MT.team_one = T.id OR MT.team_two = T.id) AND MR.winner_id != T.id) AS lost,
  (
   ((SELECT COUNT(*) FROM badminton_match_results R WHERE R.winner_id = T.id) * 2) 
     + 
   ((SELECT COUNT(*) FROM badminton_match_results R JOIN badminton_matches M  ON (M.id = R.match_id AND M.match_type = 'quarter') WHERE R.winner_id = T.id))
  ) AS Points,

  /* here is the magic */      
  (@row_num := @row_num + 1) < 4 AS row_index

FROM badminton_teams T
ORDER BY (Points) DESC
 
 这将添加一个名为row_index的额外列，其中1表示在前row_index表示不在前3。 
 
 请记住，您必须在每个SELECT之前和同一会话中调用SET 。 

There is a similar question here:
 
How to add ROW INDEX as a column to SQL SELECT query?
 
Extending from that question you want something like:
 
SET @row_num = 0;
SELECT
    T.id, T.name, T.status, IFNULL(T.image, 'no-image.png') AS DP,
    (SELECT COUNT(*)
    FROM badminton_matches MT
    WHERE (MT.team_one = T.id OR MT.team_two = T.id)) 
      AS played,
    (SELECT COUNT(*)
    FROM badminton_match_results R
    WHERE R.winner_id = T.id) AS won,
    (SELECT COUNT(*)
    FROM badminton_matches MT JOIN badminton_match_results MR
        ON (MR.match_id = MT.id)
    WHERE (MT.team_one = T.id OR MT.team_two = T.id) AND MR.winner_id != T.id) AS lost,
    (
       ((SELECT COUNT(*)
    FROM badminton_match_results R
    WHERE R.winner_id = T.id) * 2) 
         + 
       ((SELECT COUNT(*)
    FROM badminton_match_results R JOIN badminton_matches M ON (M.id = R.match_id AND M.match_type = 'quarter')
    WHERE R.winner_id = T.id))
      ) AS Points,

    /* here is the magic */
    (@row_num
:= @row_num + 1) < 4 AS row_index

    FROM badminton_teams T
    ORDER BY
(Points) DESC
 
This will add an extra column called row_index where 1 means in top 3 and 0 means not in the top 3.
 
Remember, that you must call the SET before each SELECT and within the same session.