Issues from Google Sheets

[HemanthM005]

validly(Dataset check)

• Datetime column lengths(4-10)
• - numbers in text fields
• - Minimum no. of rows or size
• - latest data on top
• - update data dictionaries like countries and districts
• - Detecting special characters
• - Flag Data-Time empty cells
• - column_names in lower case
• - Display local path for Directory
• Numeric values format(roundoff to 2 decimal digits)
• Identify Negative Values(Flag)

metafacts(Generating Metadata from Dataset)

• adding temporal coverage for datasets with dates
• Duplicate units
• Granularity (airline, language, districts, crops, gender)
• Separate granularity for Fiscal Years
• remove formats_available, is_public
• Display local path for Directory

validly metafacts(Metadata check)

• length of title (factly_dataset_name) < 200
• Spell Check
• to check whether file_path in s3
• Columns order
• length of description to be > 50