0

So I tried to do some beginner data science stuff in excel with Python Pandas, here's the original data example: Mainly what I want is the data on the left.

After coding, I could get the result to be like this: the main data I want are the yellow ones, blue ones are kinda situational.

The problem I'm facing now is: I wanna get the sum of the yellow ones' data, but can't find the right way to do it. Ultimately, I'd like to get the yellow ones' data sum, BUT, ignore those black marks that appear at row 6 (偏離) or row 22, I wanna ignore those situation's.

Here are my codes so far: enter image description here

user15301225
  • 3
  • 3
  • 2
    Please include any relevant information [as text directly into your question](https://stackoverflow.com/editing-help), do not link or embed external images of source code or data. Images make it difficult to efficiently assist you as they cannot be copied and offer poor usability as they cannot be searched. See: [Why not upload images of code/errors when asking a question?](https://meta.stackoverflow.com/q/285551/15497888) – Henry Ecker Oct 15 '21 at 02:01
  • 2
    If you need assistance formatting a small sample of your DataFrame as a copyable piece of code for SO see [How to make good reproducible pandas examples](https://stackoverflow.com/q/20109391/15497888). – Henry Ecker Oct 15 '21 at 02:01

0 Answers0