Dec-21-2019, 02:38 AM
The cells should be titled. See if your cell g has a header.
You will need an empty list called CA_rows and another called TX_rows.
Read each row, if cell g has CA then append it to CA_rows, if it equals TX then append it to TX_rows.
Here is a great example of using xlrd
Go through the example and try to get further. Post your updated work here if you need more help. You're much more likely to get code correction help than you are to get help writing code.
You will need an empty list called CA_rows and another called TX_rows.
Read each row, if cell g has CA then append it to CA_rows, if it equals TX then append it to TX_rows.
Here is a great example of using xlrd
Go through the example and try to get further. Post your updated work here if you need more help. You're much more likely to get code correction help than you are to get help writing code.