-
Notifications
You must be signed in to change notification settings - Fork 0
/
CityCompaniesExcelScriptREADME.txt
57 lines (53 loc) · 2.09 KB
/
CityCompaniesExcelScriptREADME.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
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 :)
# THIS SCRIPT IS CAPABLE TO GET DATA FOR ANY CITY.
####################################################################################################################################
##### 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.
####################################################################################################################################
TOTAL NUMBER OF COLUMNS: 31 COLUMNS
```````````````````````````````````
1) Company Full Name
2) Company Short Name
3) Company Scrip Code
4) Company Category
5) Company SEO URL EQ
6) Company Contact Person Prefix
7) Company Contact Person Firstname
8) Company Contact Person Middlename
9) Company Contact Person Lastname
10) Company Contact Person Designation
11) Company Address
12) Company City
13) Company PIN
14) Company State
15) Company Tele
16) Company Fax
17) Company Email
18) Company URL
19) Company Registrars Name
20) Company Registrars Address
21) Company Registrars Phone
22) Company Registrars Fax
22) Company Registrars Email Id
22) Company Registrars Website
25) Company ISIN
26) Company Industry
27) Company Impact Cost(%)
28) Company BC/RD
29) Company Market Lot
30) Company Listing Date
31) Company CIN
ALSO, THERE ARE MANY MORE FEATURES WHICH I HAVE NOT SCRAPPED BUT I WILL DO IT IN FUTURE IF I GET SOME MORE TIME ;)