python dataframe列数值相加,python合并dataframe中的行并将值相加

我想这会有帮助。这段代码可以处理任意数量的连续“T”，甚至可以更改要组合的字符。我在代码中添加了注释来解释它的作用。在import pandas as pd

def combine(df):

combined = [] # Init empty list

length = len(df.iloc[:,0]) # Get the number of rows in DataFrame

i = 0

while i < length:

num_elements = num_elements_equal(df, i, 0, 'T') # Get the number of consecutive 'T's

if num_elements <= 1: # If there are 1 or less T's, append only that element to combined, with the same type

combined.append([df.iloc[i,0],df.iloc[i,1]])

else: # Otherwise, append the sum of all the elements to combined, with 'T' type

combined.append(['T', sum_elements(df, i, i+num_elements, 1)])

i += max(num_elements, 1) # Increment i by the number of elements combined, with a min increment of 1

return pd.DataFrame(combined, columns=df.columns) # Return as DataFra