[Tutor] Python excel filter

john johnf at jfcomputer.com
Mon Oct 26 13:20:02 EDT 2015


take a look at python-excel

xlwt is what I use. BTW there are others Johnf



On 10/26/2015 05:21 AM, Lucas Mascia wrote:
> 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  -  Tutor at python.org
> To unsubscribe or change subscription options:
> https://mail.python.org/mailman/listinfo/tutor



More information about the Tutor mailing list