Convert CSV to XML (Python)

2010-10-11T06:20:19-07:00

Python recipe 577423 by FB36 (csv, xml).

Convert CSV to XML.

Export Oracle Database to CSV using cx_Oracle (Python)

2010-07-11T19:49:42-07:00

Python recipe 577304 by FB36 (csv, database).

Creates a CSV file for each table in the target Oracle database.

Populate SQL tables from CSV data files (Python)

2011-02-02T21:21:49-08:00

Python recipe 577559 by James Mills (conversion, csv, data, python, sql).

Just a quick recipe I developed a few years ago that I thought might be useful to others. Basically it takes as input a data file with comma separated values (CSV) and translates this into a series of SQL "INSERT" statements allowing you to then feed this into MySQL, SQLite, or any other database.

Example Usage:

$ cat cars.csv Year,Make,Model,Length 1997,Ford,E350,2.34 2000,Mercury,Cougar,2.38

$ sqlite3 cars.db "CREATE TABLE cars (Year, Make, Model, Length)"

$ ./csv2sql.py cars.csv | sqlite3 cars.db

$ sqlite3 cars.db "SELECT * FROM cars" 1997|Ford|E350|2.34 2000|Mercury|Cougar|2.38

Enjoy! Feedback welcome!

cheers James Mills / prologic

Query CSV file (Python)

2010-10-12T00:08:22-07:00

Python recipe 577419 by FB36 (csv, database). Revision 4.

The user can define a query expression for (almost) any CSV file. (The first row assumed to contain column headers.) Then the code outputs all data rows matching to the given query expression.

Correctly reading CSV files in arbitrary encodings (Python)

2011-07-25T07:29:08-07:00

Python recipe 577778 by Devin Jeanpierre (csv, unicode). Revision 4.

Recipe for using unicode files (i.e. files opened with codecs.open) with the csv module.

Read CSV with D and write it to PDF with Python (Python)

2016-10-26T17:49:00-07:00

Python recipe 580710 by Vasudev Ram (conversion, csv, data, files, formats, pdf, pdf_generation, xtopdf).

This recipe shows how to read data from a CSV file with a D program and write that data to a PDF file with a Python program - all in a single command-line invocation (after writing the individual programs, of course).

It requires the xtopdf toolkit, which you can get from:

https://bitbucket.org/vasudevram/xtopdf

Instructions for installing xtopdf:

http://jugad2.blogspot.in/2012/07/guide-to-installing-and-using-xtopdf.html

xtopdf in turn requires the open source version of the ReportLab toolkit, which you can get from:

http://www.reportlab.com/ftp (http://www.reportlab.com/ftp/reportlab-1.21.1.tar.gz)

It also requires the DMD compiler to compile the D program - this was the version used:

DMD32 D Compiler v2.071.2

Filtering CSV data by fields (cut for csv) (Python)

2011-02-02T21:39:45-08:00

Python recipe 577560 by James Mills (csv, cut, data, filter, python).

Ever wanted to take a CSV file as input, cut it up and only extract the fields that you want ?

Here's how!

$ cat cars.csv Year,Make,Model,Length 1997,Ford,E350,2.34 2000,Mercury,Cougar,2.38

$ csvcut.py -f 0 -f -1 - < cars.csv Year,Length 1997,2.34 2000,2.38

--JamesMills (prologic)

Compare CSV Inventory files (Python)

2009-08-18T14:14:04-07:00

Python recipe 576885 by Mike Burke (compare, csv).

Program will compare two CSV files using a unique ID field and save any changes to ID as well as two secondary fields (qty & price). The code was written to pick out updates from supplier inventory files.

CSV export / import of PDF bookmarks (table of contents) (Python)

2017-01-07T12:21:39-08:00

Python recipe 580743 by Jorj X. McKie (bookmarks, csv, fitz, mupdf, pdf).

Two little utilities to export or import a PDF's table of contents from / to a standard CSV file. Typical usecase would be:

export TOC to CSV file
edit CSV file
import TOC from CSV file

Custom import script for Salesforce (Python)

2011-01-21T17:43:35-08:00

Python recipe 577550 by Chris Wolf (csv, dataloader, excel, import, salesforce). Revision 2.

Normally you should try to use the Salesforce import Wizard or Apex Data Loader for importing. This script demonstrates that programmatic import can handle complex conditional logic that the Import Wizard or Data Loader cannot anticipate.

[xtopdf] Publish Delimiter-Separated Values (DSV data) to PDF (Python)

2016-12-17T19:08:33-08:00

Python recipe 580736 by Vasudev Ram (commandline, csv, data, files, formats, pdf, pdf_generation, python, tsv, utilities, xtopdf).

This recipe shows how to publish delimiter-separated values (a commonly used tabular data format) to PDF, using the xtopdf toolkit for PDF creation. It lets the user specify the delimiter via one of two command-line options - an ASCII code or an ASCII character. As Unix filters tend to do, it can operate either on standard input or on input filenames given as command-line arguments. In the case of multiple inputs via files, each input goes to a separate PDF output file.

CSV to Flat File Converter (Python)

2015-08-02T17:31:59-07:00

Python recipe 579091 by FB36 (csv, files, utility).

Converts a CSV file to a flat file (table).

Cheetah template processor for CSV and XML data (Python)

2010-05-21T10:00:14-07:00

Python recipe 577234 by Raphaël Jolivet (cheetah, csv, merge, populate, template, xml).

This script allows to populate Cheetah text templates (http://www.cheetahtemplate.org/) with XML or CSV input data.

This is useful in my day2day work, where I often need to quickly generate bunch of files based on a templates and data.

Cheetah template are very easy to write and understand, and I find it easy to use with CSV or XML data.

Ordered CSV read / write with colum based lookup (Python)

2012-03-02T12:45:29-08:00

Python recipe 578059 by Gregory Nicholas (csv, lookup).

This allows you to hold on to your csv in a dict form, do lookups and modifications, and also write it in a preserved order. You can also change which column you want to be your lookup column (making sure that there is a unique id for every row of that column. In my example of usage, it assumes that both classes are contained withing the same file named 'CustomDictReader.py'

Ordered CSV read / write with colum based lookup (Python)

2011-12-24T19:44:13-08:00

Python recipe 577996 by __nero (csv, lookup).

Oracle Database String Search using cx_Oracle (Python)

2013-07-26T21:58:30-07:00

Python recipe 577302 by FB36 (csv, database). Revision 2.

Finds all database rows in all tables that contain a given search string and outputs a CSV file for each table that has any match.

Convert CSV to XML (Python)

2012-12-17T16:16:04-08:00

Python recipe 578384 by Tom Wissing (csv, xml).

Convert CSV to XML.

Oracle Database Regex Search using cx_Oracle (Python)

2010-07-11T19:39:21-07:00

Python recipe 577303 by FB36 (csv, database).

Finds all database rows in all tables that contain any column which matches to given regex and outputs a CSV file for each table containing matches.

Most viewed recipes tagged "csv"

Convert CSV to XML (Python)

Export Oracle Database to CSV using cx_Oracle (Python)

Populate SQL tables from CSV data files (Python)

Query CSV file (Python)

Correctly reading CSV files in arbitrary encodings (Python)

Read CSV with D and write it to PDF with Python (Python)

Filtering CSV data by fields (cut for csv) (Python)

Compare CSV Inventory files (Python)

CSV export / import of PDF bookmarks (table of contents) (Python)

Custom import script for Salesforce (Python)

[xtopdf] Publish Delimiter-Separated Values (DSV data) to PDF (Python)

CSV to Flat File Converter (Python)

Cheetah template processor for CSV and XML data (Python)

Ordered CSV read / write with colum based lookup (Python)

Ordered CSV read / write with colum based lookup (Python)

Oracle Database String Search using cx_Oracle (Python)

Convert CSV to XML (Python)

Oracle Database Regex Search using cx_Oracle (Python)