Mar-22-2017, 10:36 PM
(Mar-22-2017, 10:15 PM)zivoni Wrote: Pandas has no problems to count values in boolean columns, but there are some problems with your code:
When you convert your list to a dataframe, you are not supplying a column name, neither you rename the column later - so your dataframe has only one column 0 (numerical index). When you try to select test2['sum1'], it raises an error - there are only integers in range index (it probably raises KeyError somewhere too). You can access your column with test2[0] or with ix/iloc/loc, but better would be to rename it or provide column name when you create the dataframe (either columns parameter or pd.DataFrame({'sum1': test}) ).
And you are appending to test only in else clause, so your list will consist only of "False"s (misindented line?).
Thank you so much for the help. I forgot I needed to supply the DataFrames argument with a columns parameter if I wanted to reference it as "sum1." Additionally, I did forget to add an append method in my if clause as well. Thanks for noticing that.