If you're used to Excel, then it might be worth loading the data into Access and then using the "Data from Access" wizard to allow Excel to crunch the data, pivots, etc.
They ought to offer a zipped download too... would be a c.50mb download, rather than a 550mb one! On 27 December 2011 15:55, Caroline Flyn <[email protected]> wrote: > Hi all, > > Does anyone know of anyone/ any organisations who are analysing the new > GP-practice level prescription data? > > Or could you recommend suitable software that could be used? It's all in > CSV format, but obviously an enormous file. > > The NHS warns: > *"Note: Due to the large file size (over 500MB) standard spreadsheet > applications will not be able to handle the volumes of data contained in > the monthly datasets. Data users will need to analyse the information using > specialist data-handling software."* > > > http://www.ic.nhs.uk/news-and-events/news/gp-practice-level-prescribing-data-now-available > > All advice welcomed... > > _______________________________________________ > developers-public mailing list > [email protected] > https://secure.mysociety.org/admin/lists/mailman/listinfo/developers-public > > Unsubscribe: > https://secure.mysociety.org/admin/lists/mailman/options/developers-public/rory%40viscero.com > -- Rory Geoghegan +44 7843 097 543
_______________________________________________ developers-public mailing list [email protected] https://secure.mysociety.org/admin/lists/mailman/listinfo/developers-public Unsubscribe: https://secure.mysociety.org/admin/lists/mailman/options/developers-public/archive%40mail-archive.com
