Audit an Aegean earthquake CSV before charting
Check a USGS earthquake export before an editor turns it into a chart. The file contains catalog records for February 1–7, 2025 UTC in a box around the southern Aegean, limited to magnitude 3.5 and above.
The bounding box is 35–38° N and 24–27° E. Use the saved CSV so the review can be repeated even if catalog records change. USGS catalog query · Field definitions
入力データ
役に立つ結果はどのようなものか
Count data records and header columns. Report any records with a different number of fields and any exact repeats.
List the number of blank cells in each column. Parse quoted fields as CSV and leave the original export intact.
Deliver a CSV audit and note the export’s date window, area and minimum magnitude for the editor.
参考成果物
| Check | Result |
|---|---|
| Data records | 208 |
| Columns | 22 |
| Records with a different number of columns | 0 |
| Exact repeated records | 0 |
| Columns containing blank values | 0 |
The report counts parsed CSV records and treats quoted commas in place names as part of the field. It reports blank values by column and leaves the source file untouched.
Label the chart with the UTC date window, the bounding box, and the magnitude cutoff. The report checks the file structure. A chart still needs a choice of time zone and an explanation of which magnitudes the export includes.