Python的Excel数乘以一个负数和正数出现(计数/频率)

I would like python to count the number of time a negative and positive number appears in binary [1 positive and 0 negative]. Furthermore, I would like Python to compute a percentage of how many positive numbers exist from the total count. I am having a very hard time figure this out when working with Python Excel.

我想让python计算二进制[1正0负]中出现负数和正数的次数。此外，我还希望Python从总数中计算出有多少个正数的百分比。在使用Python Excel时，我很难理解这一点。

This is the code that I have right now:

这是我现在的代码:

import csv

with open('Weather30states.csv', 'r') as file1:
     val = list(csv.reader(file1))[2]
     val1 = val[0:4]

with open('FL%.csv', 'r') as file2:
    reader = csv.reader(file2)
    reader.next() # this skips the first row of the file
    # this iteration will start from the second row of file2.csv
    conditionMet = False
    for row in reader:
        if conditionMet == True:
            print "FA,",row[0],',', ','.join(row[1:5])
            conditionMet = False # or break if you know you only need at most one line
        if row[1:5] == val1:
           conditionMet = True

When I run this code, what I get in the output window is this:

当我运行这段代码时，我在输出窗口中得到的是:

FA, -1.97% , 0,0,1,0
FA, -0.07% , 0,0,1,1
FA, 0.45% , 0,1,1,1
FA, -0.07% , 0,0,1,1
FA, -0.28% , 0,0,1,1

What I want to get is this:

我想要得到的是

1, 0, FA, -1.97% , 0,0,1,0
2, 0, FA, -0.07% , 0,0,1,1
3, 1, FA, 0.45% , 0,1,1,1
4, 0, FA, -0.07% , 0,0,1,1
5, 0, FA, -0.28% , 0,0,1,1

Total Count = 5
Percentage of Positive numbers = .20 %

1 个解决方案

#1

Use two counter variables to track of the total count and number of positives. Set them to 0 in the beginning, and then inside of your loop, increment them by using += 1 whenever you want to add 1.

使用两个计数器变量来跟踪总计数和阳性的数量。在开始时将它们设置为0，然后在循环内部，在添加1时使用+= 1对它们进行递增。

Then test whether the percentage is greater than 0 by stripping out the percentage sign and then converting the string into a number using if float(row[0].strip('%')) > 0. You can change this to >= if you want to include 0 in the "positive" category.

然后测试百分比是否大于0，去掉百分比符号，然后使用if float(行[0].strip('%')) > 0将字符串转换为数字。如果要将0包含在“正数”类别中，可以将其更改为>=。

totalCount = 0
numberOfPositives = 0

with open('FL%.csv', 'r') as file2:
    reader = csv.reader(file2)
    reader.next() # this skips the first row of the file
    # this iteration will start from the second row of file2.csv
    conditionMet = False
    for row in reader:
        if conditionMet == True:
            if float(row[0].strip('%')) > 0: # change > to >= if you want to count 0 as positive
                print "FA, 1",row[0],',', ','.join(row[1:5]) # print 1 if positive
                numberOfPositives += 1 # add 1 to numberOfPositives only if positive
            else:
                print "FA, 0",row[0],',', ','.join(row[1:5]) # print 0 if not positive
            totalCount += 1 # add 1 to totalCount regardless of sign
            conditionMet = False # or break if you know you only need at most one line
        if row[1:5] == val1:
           conditionMet = True

Then you can calculate the sum and percentage you need from totalCount and numberOfPositives:

然后你可以计算你需要的总数和百分比，从总数和数量的积极:

print 'Total Count =', totalCount
print 'Percentage of Positive numbers =', numberOfPositives * 100./totalCount, '%'

#1