Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Summing up rows and columns
#1
result = [[1, 2, 3, 4],
          [5, 6, 7, 8],
          [9, 10, 11, 12],
          [13, 14, 15, 16]]

qq = sum(result[3])
A. I can sum up all the rows using sum(). But how to sum the columns? Beside using the long method result[0][0]+result[1][0]+result[2][0]+result[3][0].

B. sum() will not work if one of the list elements is blank. Any way to resolve this?

Many thanks.

P/S

Found the answers. I should try harder n my search! Ha.

https://www.geeksforgeeks.org/python-col...sted-list/
Reply
#2
You could transpose the rows into columns and then use sum
from itertools import zip_longest

rows = [[1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12], [13, 14, 15, 16]]

print(rows)


def transpose_rows(rows):
    return tuple(zip_longest(*rows, fillvalue=0))


columns = transpose_rows(rows)

print(columns)

print(sum(columns[3]))
Output:
[[1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12], [13, 14, 15, 16]] ((1, 5, 9, 13), (2, 6, 10, 14), (3, 7, 11, 15), (4, 8, 12, 16)) 40
Reply
#3
(Aug-13-2021, 06:19 AM)Yoriz Wrote: You could transpose the rows into columns and then use sum
from itertools import zip_longest

rows = [[1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12], [13, 14, 15, 16]]

print(rows)


def transpose_rows(rows):
    return tuple(zip_longest(*rows, fillvalue=0))


columns = transpose_rows(rows)

print(columns)

print(sum(columns[3]))
Output:
[[1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12], [13, 14, 15, 16]] ((1, 5, 9, 13), (2, 6, 10, 14), (3, 7, 11, 15), (4, 8, 12, 16)) 40
Noted. Good idea!
Reply
#4
arr1 = [[1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12], [13, 14, 15, 16]]
arr2 = [list(col) for col in zip(*arr1)]
print(arr2)
print(sum(arr2[3]))
Output:
[[1, 5, 9, 13], [2, 6, 10, 14], [3, 7, 11, 15], [4, 8, 12, 16]] 40
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Converting a json file to a dataframe with rows and columns eyavuz21 13 4,366 Jan-29-2023, 03:59 PM
Last Post: eyavuz21
  Summing up set elements(HH:MM:SS) tester_V 4 1,162 Dec-22-2022, 10:03 AM
Last Post: perfringo
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,866 Dec-12-2022, 08:22 PM
Last Post: jh67
  Check DataFrames with different sorting in columns and rows Foxyskippy 0 771 Nov-19-2022, 07:49 AM
Last Post: Foxyskippy
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 1,624 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
  making variables in my columns and rows in python kronhamilton 2 1,608 Oct-31-2021, 10:38 AM
Last Post: snippsat
  rows from sql query need to write to a file as columns sjcsvatt 6 2,380 Oct-09-2021, 12:45 AM
Last Post: snippsat
  Merging spreadsheets with the same columns and extracting rows with matching entries johnbernard 3 9,289 Aug-19-2021, 03:08 PM
Last Post: johnbernard
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,105 May-04-2021, 10:51 PM
Last Post: rhat398
  Indexing [::-1] to Reverse ALL 2D Array Rows, ALL 3D, 4D Array Columns & Rows Python Jeremy7 8 7,087 Mar-02-2021, 01:54 AM
Last Post: Jeremy7

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020