Sum all columns with a wildcard name search using Python Pandas Sum all columns with a wildcard name search using Python Pandas python python

Sum all columns with a wildcard name search using Python Pandas


python wildcard pandas

I found the answer.

Using the data, dataframe from the question:

from pandas import *P1Channels = data.filter(regex="P1")P1Sum = P1Channels.sum(axis=1)

python wildcard pandas

List comprehensions on columns allow more filters in the if condition:

In [1]: df = pd.DataFrame(np.arange(15).reshape(5, 3), columns=['P1S1', 'P1S2', 'P2S1'])In [2]: dfOut[2]:    P1S1  P1S2  P2S10     0     1     21     3     4     52     6     7     83     9    10    114    12    13    14In [3]: df.loc[:, [x for x in df.columns if x.startswith('P1')]].sum(axis=1)Out[3]: 0     11     72    133    194    25dtype: int64

python wildcard pandas

Thanks for the tip jbssm, for anyone else looking for a sum total, I ended up adding .sum() at the end, so:

P1Sum= P1Channels.sum(axis=1).sum()

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last