This article is the second in a series of articles about data mining tools written in Python CGI that make common data mining tasks faster and easier. The first article in the series can be seen here:
This tool is very similar to the previous tool, except it is made for copying and pasting a row of spreadsheet data instead of a column of spreadsheet data. Instead of having to parse spreadsheets from within your script, all you have to do is select a row of data in the spreadsheet , then copy and paste the data into the web form. With the click of a button, the script will produce a Pythonic list (array) that can be copied into your script.
The full screen version of this tool can be seen here:
This tool required a slight difference in parsing logic from the column_to_array.py script. In this case, I just needed to split the row string on the tab
'\t'character. For example:
# Convert the row into an array using split s = s.split("\t")
Here is the tool, loaded into an iframe: