autoline.ipynb 6.8 KB
import csv_import
import pandas as pd
conn = csv_import.conn_string(csv_import.target_dsn)
df = pd.read_sql_table("CRMVehicle", conn, schema="import")
df.describe()| COMP | Vehicle_BKVehicleID | Vehicle_DMSVehicleNumber | Vehicle_CRMVehicleNumber | Vehicle_Make | Vehicle_MakeID | Vehicle_Model | Vehicle_ModelID | Vehicle_ModelLine | Vehicle_ModelLineID | ... | Vehicle_PreviousLastName | Vehicle_PreviousUsage | Vehicle_VehicleModelDescription | Vehicle_GovermentNumber | Vehicle_BuyingLocation | Vehicle_VehicleModelGroupCode | Vehicle_EngineSize | Vehicle_VehicleWarrantyExpiryDate | Vehicle_CompanyVehicle | Vehicle_LiveStatus | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | 38875 | 38875 | 38875 | 38875 | 38875 | 38875 | 38875 | 38875 | 38875 | 38875 | ... | 38875 | 38875 | 38837 | 38837 | 38837 | 38698 | 38698 | 38698 | 38698 | 38698 |
| unique | 1 | 38698 | 38698 | 38698 | 12 | 12 | 1902 | 2918 | 323 | 395 | ... | 2236 | 1 | 15088 | 31636 | 30 | 4 | 442 | 7047 | 2 | 2 |
| top | 10 | 10_26195 | 47372 | 47372 | Opel | O_O | nicht definiert | ALLG | nicht definiert | ALLG | ... | Opel Zafira B Enjoy | 0 | 0 | L | ||||||
| freq | 38875 | 2 | 2 | 2 | 19501 | 19501 | 14795 | 14958 | 16084 | 16218 | ... | 35855 | 38875 | 260 | 6728 | 32014 | 38646 | 17319 | 13532 | 29892 | 19360 |
4 rows × 70 columns