Custom extractor for PyCharm - copy tables to a list of dicts

Python-List.py.groovy

import static com.intellij.openapi.util.text.StringUtil.escapeStringCharacters as escapeStr

SEPARATOR = ", "
QUOTE     = "\""
NEWLINE   = System.getProperty("line.separator")

def record(columns, dataRow) {
    OUT.append("    {").append(NEWLINE)

    columns.eachWithIndex { column, idx ->
        def skipQuote = dataRow.value(column).toString().isNumber() || dataRow.value(column) == null
        def stringValue = dataRow.value(column) == null ? "None" : FORMATTER.format(dataRow, column)

        OUT.append("        ")
           .append(QUOTE).append(column.name()).append(QUOTE)
           .append(": ")
           .append(skipQuote ? "": QUOTE).append(escapeStr(stringValue)).append(skipQuote ? "": QUOTE)
           .append(SEPARATOR + NEWLINE)
    }

    OUT.append("    },").append(NEWLINE)
}


OUT.append("data = [").append(NEWLINE)

ROWS.each { row -> record(COLUMNS, row) }

OUT.append("]")

Docs for 'installing' this extractor: https://www.jetbrains.com/help/pycharm/data-extractors.html#creating-any-text-extractor-with

You can then copy a table (left) and paste it as valid Python (right):

Copied from https://github.com/aoiaoi/jetbrains-intellij-extractors/blob/master/src/Python-Dictionaries.py.groovy with handling for None and quotes added.