Extra files and scripts for generating various test data.

Python script to generate a typical csv data file, based on the structure of a real research dataset, but with randomized dummy data.

Python script to generate a csv data file with 99 columns, filled with random data and using as many different column formats as possible. Used for testing the automatic column detection algorithm.

Python script to generate a csv data file with random unicode characters, used for testing the syntax highlighting and different Windows region/code page settings.

Python script to determine the syntax highlighting colors. The script determines color sequences where there won't be columns with similar colors next to each other (red/orange or blue/cyan). The script selects a color sequence where each color is as different as possible from the next, see the results here. This makes it easier to distinguish columns while also making it more accessible for people who are color blind (as opposed to using a color scheme like this).

Note: Technically the CSV Lint plugin can use max 31 different column colors. However, for 16 or more colors the script starts generating very similar looking colors, which kind of defeats the purpose, 12 colors seems to be the optimum. The 16 colors xml is provided here just for the sake of completion.

Syntax highlighting configuration for different predefined color sets

BdR©2019-2024 Free to use - send questions or comments: Bas de Reuver - [email protected]