Skip to content

Instantly share code, notes, and snippets.

@amitpatelx
Created October 6, 2020 10:49
Show Gist options
  • Save amitpatelx/a44a876e125cb56c924b8564625588fd to your computer and use it in GitHub Desktop.
Save amitpatelx/a44a876e125cb56c924b8564625588fd to your computer and use it in GitHub Desktop.
Sample Spider Report
******* Summary *******
🏷 File Name : RobertsforsbostaderSpider
🗒 Total Items : 4
💥 Total Errors : 23
******* Attributewise Summary *******
+--------------+------------+
|Attribute |Total Issues|
+--------------+------------+
|square_meters | 4|
|room_count | 4|
|available_date| 3|
|rent | 4|
|image | 4|
|currency | 4|
+--------------+------------+
******* Recordwise Error Details *******
+--+--------------+-----------------------------------+
|No|Attribute |Issue |
+--+--------------+-----------------------------------+
|1 |square_meters |Type Mismatch |
|1 |room_count |Type Mismatch |
|1 |available_date|Type Mismatch |
|1 |rent |Type Mismatch |
|1 |image |Unsupported attribute. May be typo.|
|1 |currency |Missing Value |
+--+--------------+-----------------------------------+
+--+-------------+-----------------------------------+
|No|Attribute |Issue |
+--+-------------+-----------------------------------+
|2 |square_meters|Type Mismatch |
|2 |room_count |Type Mismatch |
|2 |rent |Type Mismatch |
|2 |image |Unsupported attribute. May be typo.|
|2 |currency |Missing Value |
+--+-------------+-----------------------------------+
+--+--------------+-----------------------------------+
|No|Attribute |Issue |
+--+--------------+-----------------------------------+
|3 |square_meters |Type Mismatch |
|3 |room_count |Type Mismatch |
|3 |available_date|Type Mismatch |
|3 |rent |Type Mismatch |
|3 |image |Unsupported attribute. May be typo.|
|3 |currency |Missing Value |
+--+--------------+-----------------------------------+
+--+--------------+-----------------------------------+
|No|Attribute |Issue |
+--+--------------+-----------------------------------+
|4 |square_meters |Type Mismatch |
|4 |room_count |Type Mismatch |
|4 |available_date|Type Mismatch |
|4 |rent |Type Mismatch |
|4 |image |Unsupported attribute. May be typo.|
|4 |currency |Missing Value |
+--+--------------+-----------------------------------+
******* Attributes with missing value *******
+---------------------+-------------+-------+
|Attribute |Total Missing|Total %|
+---------------------+-------------+-------+
|available_date | 3| 75|
|balcony | 4| 100|
|bathroom_count | 4| 100|
|currency | 4| 100|
|deposit | 4| 100|
|dishwasher | 4| 100|
|elevator | 4| 100|
|energy_label | 4| 100|
|external_id | 4| 100|
|external_images_count| 4| 100|
|floor_plan_images | 4| 100|
|furnished | 4| 100|
|heating_cost | 4| 100|
|images | 4| 100|
|landlord_email | 4| 100|
|landlord_name | 4| 100|
|landlord_phone | 4| 100|
|latitude | 4| 100|
|longitude | 4| 100|
|parking | 4| 100|
|pets_allowed | 4| 100|
|prepaid_rent | 4| 100|
|swimming_pool | 4| 100|
|terrace | 4| 100|
|utilities | 4| 100|
|washing_machine | 4| 100|
|water_cost | 4| 100|
|zipcode | 4| 100|
+---------------------+-------------+-------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment