-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathPythonExcelScriptREADME.txt
79 lines (73 loc) · 4.1 KB
/
PythonExcelScriptREADME.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
AUTHOR DATA
```````````
# __author__ = "Dhrumil Amish Shah"
# __copyright__ = "Copyright 2019"
# __credits__ = ["Dhrumil Amish Shah"]
# __version__ = "1.0.0"
# __maintainer__ = "Dhrumil Amish Shah"
# __github__ = "https://github.com/DhrumilShah98/"
# __linkedIn__ = "https://linkedin.com/in/dhrumilshah98/"
####################################################################################################################################
# NOTE: I CAN NOT SHARE THE NAME OF THE WEBSITE, JSON FILE OR EXCEL SHEET.
# IF YOU WANT JSON OR EXCEL SHEET, CONTACT ME :)
# I WAS ABLE TO GET TOTAL 1238 CAR DETAILS. PRETTY AMAZING RIGHT :)
####################################################################################################################################
##### Fetch data from 'car_website_name' Website.
##### Lucky Me: I was able to find a JSON which contains a lot of data.
##### I invested a lot of time to find a main data source on "car_website_name's"
##### I found one data source (JSON file) which I used to call multiple URLs which were within it
# from which i got chunks of data. [CONTAINS A LOT DATA OUT OF WHICH I USED ONLY FEW]
##### Then I cleaned all the data and I decided what should I keep and what I should not. (TEDIOUS TASK)
##### I used that file (Here I downloaded it first, but instead I could also have made a network call)
##### Well..... I downloaded it first.
##### Below is the code. It calls multiple URLs one by one, get required data by parsing and then make a excel structure out of it.
##### Summarizing....
##### Got a data source (JSON form), called multiple URLS by analyzaing the JSON form,
##### from multiple URLs, I got a chunks of data after which I created a simple excel structure.
##### You can contact me on linkedIn if you want this data either in Excel or JSON.
####################################################################################################################################
NOTE: I HAVE NOT ADDED SPECIFICATIONS FOR EACH CAR VARIANT IN THE EXCEL SHEET. I AM WORKING ON IT CURRENTLY
BUT, I HAVE ADDED ALL THE SPECIFICATIONS IN THE JSON. I AM WORKING TO DO SAME IN THE EXCEL TOO.
####################################################################################################################################
TOTAL NUMBER OF COLUMNS: 38 COLUMNS [Also, for each variant there are more than 45 different specifications which I have not added in the excel sheet]
``````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````
1) brandName Eg: Hyundai
2) name Eg: Hyundai Grand i10
3) engine Eg: 1197cc
4) mileage Eg: 17.0kmpl
5) seating Eg: 5 seater
6) modelShortName Eg: Grand i10
7) subText Eg: 1197cc, 18.9kmpl
8) fuelName Eg: Petrol
9) carVariantId Eg: Hyundai Grand i10 1.2 Kappa Sportz Dual Tone
10) title Eg: Hyundai Grand i10 1.2 Kappa Sportz Dual Tone
11) highWayAvg Eg: 18.9
12) urbanAvg Eg: 19.1
13) displayCarVariantId Eg: Hyundai Grand i10 1.2 Kappa Sportz Dual Tone
14) vehicleType Eg: Hatchback
15) priceRange Eg: 6.4 Lakh
16) modelPriceRange Eg: 4.97 - 7.63 Lakh
17) oem_name Eg: hyundai
18) model_name Eg: hyundai grand i10
19) variant_name Eg: hyundai-grand-i10-1.2-kappa-sportz-dual-tone
20) car_segment Eg: hatchback cars
21) engine_cc Eg: 1197
22) fuel_type Eg: petrol
23) transmission_type Eg: manual
24) brand_new Eg: hyundai
25) model_new Eg: hyundai grand i10
26) display_model_new Eg: Hyundai Grand i10
27) variant_new Eg: hyundai grand i10 1.2 kappa sportz dual tone
28) fuel_type_new Eg: petrol
29) engine_capacity_new Eg: 1000cc - 2000cc
30) max_engine_capacity_new Eg: 1197
31) min_engine_capacity_new Eg: 1197
32) transmission_type_new Eg: manual
33) mileage_new Eg: 15 kmpl and above
34) max_mileage_new Eg: 18
35) min_mileage_new Eg: 18
36) seating_capacity_new Eg: 5
37) transmission_type Eg: manual
38) url - JSON Eg: url for many other data in json form
+ 45 MORE SPECIFICATIONS FOR EACH CAR VARIANT.
ALSO, THERE ARE MANY MORE FEATURES WHICH I HAVE NOT SCRAPPED BUT I WILL DO IT IN FUTURE IF I GET SOME MORE TIME ;)