A.) I need data extraction done on a web site that uses Joomla (and a it looks like a Sobi2, which is available from www.sigsiu.net.)
I will give you the site to view via PM.
The site is a basic website directory style of site, it should be easily completed using beautiful soup or scrapy.
I need the data in a CSV format.
B.) I need a CSV to JSON and JSON to CSV module written in python. (please take a look at these three snippets)
[url removed, login to view]
[url removed, login to view] (CSV to JSON)
[url removed, login to view] (JSON to CSV)
The module needs to be able to convert arbitrary CSV file in proper format to JSON and JSON to a CSV file.
input and output -->
It should be capable of reading and writing to text files.
It should be capable creating a collection of JSON objects for reuse in other programs.
It should be capable printing out to the terminal when used on the command line for debugging.
Error handling ---->
The library should fail gracefully.
The library needs to properly sanitize the CSV files.
Other Items?? (perhaps handle yaml? )
*Bonus if you can create a Django App using the module.
I want to be able to use this python module on the command line and in django applications to move data around between formats.
Often, I need to have people check over data in excel to insure that it is written properly before posting to our web site in bulk. As a result, I then need to convert the reviewed data from CSV to JSON in order to add the JSON to Django applications (also the reverse get data in JSON and need to convert to CSV to edit in Excel). I'd like a nice module to handle this process.
CSV to JSON / JSON to CSV
These modules should be used for csv and json parsing: