[Tutor] Python excel filter

[Lucas Mascia]

Hello,

I would like some guidance in a way to filter data from an excel sheet
(.xlsx)

I will be exporting an extensive table from a website with 400x20 infos. In
this sheet, I need to apply 3 or 4 filters and collect the amount of info
it shows then. Eg.:

1 - Export .xlsx from website
2 - Run python to filter
2.1 - Filter by client A
2.2 - Filter by task A
2.3 - Filter by Person A
3 - Repeat filter for different clients, tasks and persons
4 - Collect the amount each person does inside each client.


Please Help guide my through a starting poing

Thank you,

Lucas R. Mascia

| VIEW MY | <http://br.linkedin.com/pub/lucas-mascia/61/93/8b>

"It is not the strongest of the species that survives, nor the most
intelligent that survives. It is the one that is most adaptable to change."
- Darwin.
_______________________________________________
Tutor maillist - ***@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor

[Alan Gauld]

Post by Lucas Mascia
Hello,
I would like some guidance in a way to filter data from an excel sheet
(.xlsx)
I will be exporting an extensive table from a website with 400x20 infos. In
this sheet, I need to apply 3 or 4 filters and collect the amount of info
1 - Export .xlsx from website

Can you export to CSV instead? Its much easier to work with CSV files
using the standard library than to use Excel sheets natively. There are
Excel modules that you can download but CSV is standard functionality
and Excel CSV format is the default.

Post by Lucas Mascia
2 - Run python to filter
2.1 - Filter by client A
2.2 - Filter by task A
2.3 - Filter by Person A

Thats pretty meaningless without knowing the format of the tables.

Post by Lucas Mascia
3 - Repeat filter for different clients, tasks and persons

I'm not sure what you mean by "repeat filter" can you elaborate?

Post by Lucas Mascia
4 - Collect the amount each person does inside each client.

What do you mean "the amount"? Is that a column in the table
or are you meaning a count of the number of entries by user?

Without a view of the table format its hard to be any more specific.
--
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.amazon.com/author/alan_gauld
Follow my photo-blog on Flickr at:
http://www.flickr.com/photos/alangauldphotos


_______________________________________________
Tutor maillist - ***@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor

[john]

take a look at python-excel

xlwt is what I use. BTW there are others Johnf

Post by Lucas Mascia
Hello,
I would like some guidance in a way to filter data from an excel sheet
(.xlsx)
I will be exporting an extensive table from a website with 400x20 infos. In
this sheet, I need to apply 3 or 4 filters and collect the amount of info
1 - Export .xlsx from website
2 - Run python to filter
2.1 - Filter by client A
2.2 - Filter by task A
2.3 - Filter by Person A
3 - Repeat filter for different clients, tasks and persons
4 - Collect the amount each person does inside each client.
Please Help guide my through a starting poing
Thank you,
Lucas R. Mascia
| VIEW MY | <http://br.linkedin.com/pub/lucas-mascia/61/93/8b>
"It is not the strongest of the species that survives, nor the most
intelligent that survives. It is the one that is most adaptable to change."
- Darwin.
_______________________________________________
https://mail.python.org/mailman/listinfo/tutor

_______________________________________________
Tutor maillist - ***@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor