str.findall & to_json_normalize

1. strFindall — all regex matches per element

Mirrors pandas.Series.str.findall(pat). Returns a Series where each value is a JSON-encoded array of all non-overlapping matches.

With capture groups

Null / NaN handling

2. strFindallCount — count matches per element

3. strFindFirst — first match per element

4. strFindallExpand — expand capture groups into a DataFrame

Mirrors pandas.Series.str.extract(pat, expand=True).

5. toJsonDenormalize — flat DataFrame → nested JSON

The inverse of jsonNormalize: takes a DataFrame with dot-separated column names and reconstructs nested JSON objects.

Custom separator

Drop null values

toJsonRecords — orient="records"

toJsonSplit — orient="split"

toJsonIndex — orient="index"