Video Guide for Cleaning
"Team Board - Google Sheet" for coordinating
- Example of a proper table:
-
The first row should be the table title.
-
The second row is optional, sometimes this will be empty, other time this will have a sentence.
-
Then third row will contain the column titles. If you see that the fourth row and fifth row also contain column titles, then merge those cells with the other column titles so that they are in the same cell and there is only one column title row.
-
The rest of the rows are data tables. Usually the first column contains the upazila names. And the other columns contain numerical or word data.
- Random characters and string in the cells, e.g. "Bagerhat\t123" or "Ban gla d esh"
- The column titles are not in a single row, they are in two or three rows. Merge the cells to make them into a single row.
-
Table title is missing in the first row.
-
Spelling mistakes in the names.
-
Incorrect total values in some columns in the csv and in the pdf as well.
-
Table units are merged with the 2nd level headings in the column title. Remove table units from the column title and copy unit to the 2nd row right below the Table title.
-
Two tables are merged in one file.
-
Column title 'Upazila' missing.
-
???
Feel free to improve this file by editing.