Easier way to do this?

20/20 Lab lab at 2020fresno.com
Thu Oct 5 11:22:23 EDT 2017


On 10/05/2017 07:28 AM, Neil Cerutti wrote:
> On 2017-10-04, 20/20 Lab <lab at 2020fresno.com> wrote:
>> It's not quite a 'learning exercise', but I learn on my own if
>> I treat it as such.  This is just to cut down a few hours of
>> time for me every week filtering the file by hand for the
>> office manager.
> That looks like a 30-second job using a pivot table in Excel.
> Office manager, learn thy Excel!
>
> On the other hand, I think Python's csv module is a killer app,
> so I do recommend taking the opportunity to learn csv.DictReader
> and csv.DictWriter for your own enjoyment.
>
It would be if our practice management software would export to excel, 
or even a realistic csv.  Problem is that it only exports to csv and 
it's 80-90% garbage and redundant information.  I've taken to bringing 
the csv into excel and refining it so I can do that, but again.  I'd 
rather take half a second and have a program do it for me.  ;)



More information about the Python-list mailing list