Python Forum
summing rows/columns more quickly
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
summing rows/columns more quickly
#2
for index, row in df.iloc[:,0:64].iterrows():
    row=numpy.array(row)  
    row=row.reshape(8,8)
    row_sum=row.sum(axis=0)
    column_sum=row.sum(axis=1)
    concatenated = np.concatenate((row_sum,column_sum),axis=0)              #################
    result=pandas.DataFrame(concatenated.reshape(1,16), columns=[i for i in range(0,16)])#############
    df_2=df_2.append(result)
i concatenated row_sum & column_sum 1st, then called Dataframe() once... did this in python 2.7 just in case not working
swallow osama bin laden
Reply


Messages In This Thread
summing rows/columns more quickly - by jon0852 - Feb-11-2018, 06:45 AM
RE: summing rows/columns more quickly - by ka06059 - Feb-11-2018, 05:16 PM
RE: summing rows/columns more quickly - by jon0852 - Feb-11-2018, 11:21 PM
RE: summing rows/columns more quickly - by ka06059 - Feb-12-2018, 02:24 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Parsing and summing time deltas (duration) onto bar + pie charts using pandas - - DRY Drone4four 2 666 Feb-10-2024, 06:04 PM
Last Post: Drone4four
  Merging rows and adding columns based on matching index pythonnewbie78 3 907 Dec-24-2023, 11:51 AM
Last Post: Pedroski55
  Pandas: summing columns conditional on the column labels ddd2332 0 2,172 Sep-10-2020, 05:58 PM
Last Post: ddd2332
  read_csv error and rows/columns missing karlito 9 5,490 Nov-11-2019, 06:48 AM
Last Post: karlito
  Drop rows if a set of columns has a value dervast 1 2,035 Sep-12-2019, 04:18 PM
Last Post: sd_0912
  display graph in columns and rows william888 1 1,903 Jul-02-2019, 10:19 AM
Last Post: dataman
  Imported csv, column text converted to number but not summing Ecniv 4 2,958 Jun-21-2019, 02:03 PM
Last Post: Ecniv
  Dropping all rows of multiple columns after the max of one cell Thunberd 2 3,019 Jun-01-2018, 10:18 PM
Last Post: Thunberd
  Get rows with same value from dataframe of particular columns angelwings 1 2,764 Apr-11-2018, 02:40 AM
Last Post: scidam
  Stack dataframe columns into rows klllmmm 0 3,061 Sep-03-2017, 02:26 AM
Last Post: klllmmm

Forum Jump:

User Panel Messages

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