Data profiler

Check an EDC export: types, gaps, duplicates, outliers.

Upload an export from any EDC as CSV, TXT or XLSX. The profile shows each column's type, missing values, distinct values, range or top values, and findings.

What it looks for

• non-numeric values in numeric columns and outliers (beyond three interquartile ranges);
• unreadable dates, dates in the future or before 1900, mixed date formats;
• the same value in different case (“Yes” and “yes”), extra spaces;
• fully duplicated rows and repeated column names;
• empty and half-empty columns, a unique key candidate and the subject column.

Encoding (UTF-8, Windows-1251) and delimiter are detected automatically.

An Excel workbook with several sheets

When a workbook has several sheets with data, the profile reads each one and shows it on its own tab. The data sheet opens first, not the cover page: in a MainEDC Modular export, for example, “Export Data” opens, and “Data export cover page” (the export parameters, “Parameter” and “Value”) has its own tab marked “cover”. Hidden and empty sheets are skipped. The row limit applies to the whole workbook: when it is reached, the profile names the sheets it did not read.

Other tools that read one table from a file also skip the cover page and take the first sheet with data.

Nothing is stored. The file is read in memory and discarded; the log keeps only the number of rows, columns and findings. Size and daily limits are set by the Portal Owner.