Python help!

I am writing a program that reads an excel file to answer some questions. In the data sheet (attached image) each line shows the XRD data of all the materials given a specific Intensity (Arb. Units). AlNi* are the name of the materials. Each column shows the XRD data of one material. I have written the code to count the materials but am trying to find a way to not include intensity when it counts the materials as well as the other questions listed if possible! I attached an screen shot of the data excel page and of the code i have written now that i need to modify to not include the intensity for #1.

1. How many materials the data has?

2. How many missing values the data has? (missing value is represented as )

3. How many different Intensity the data has?

1 file-open("4material.csv", "r") 2 lines-file. readlines () # print (lines) 4 5#1 6 attributes-lines [0].strip).split(",") 7 mapA2Index-h 8 index-0 9 for x in attributes: mapA2Index [x.strip()]-index index+-1 10 12 print("How many materials the data has:", index)