Go Back   Team-BHP > BHP India > The Indian Car Scene


Reply
 
Thread Tools Search this Thread
Old 22nd October 2014, 10:31   #16
Team-BHP Support
 
ampere's Avatar
 
Join Date: Sep 2009
Location: Bangalore
Posts: 15,604
Thanked: 8,594 Times
Default Re: Used Honda City - Year vs Price Analysis

Nice one there Kenney. Some questions:


- Would be interesting to know a high level picture of how you data mine (Dont need the specifics)?
- Can you take the two data and plot ISO-Odo/Year and ISO-Year/Odo charts?
ampere is offline   Reply With Quote
Old 22nd October 2014, 12:57   #17
BHPian
 
Join Date: May 2013
Location: Bangalore
Posts: 325
Thanked: 174 Times
Default Re: Used Honda City - Year vs Price Analysis

Quote:
Originally Posted by kenneyjacob View Post
Wrote a small program to scrap data from OLX, it was a little tricky as they have some good counter measures set-up to prevent such attempts.
Since they have counter measures to prevent this, I assume this is something they wanna protect and keep confidential.

Counter measures = Virtual Locks in my understanding, hence breaking a lock can open you to law suits

I am not sure of the laws and the technicality, would be good if you can explain the approach you followed to get the data.
2000rpm is online now   Reply With Quote
Old 22nd October 2014, 14:14   #18
Newbie
 
Join Date: Jun 2014
Location: Trivandrum
Posts: 20
Thanked: 67 Times
Default Re: Used Honda City - Year vs Price Analysis

Quote:
Originally Posted by ampere View Post
- Would be interesting to know a high level picture of how you data mine (Dont need the specifics)?
- Can you take the two data and plot ISO-Odo/Year and ISO-Year/Odo charts?
There are many ways to mine data. You can use a tool called Selenium, which is testing tool primarily used to automate things we do on a browser. So it can browse pages exactly like humans do and save specific information we need from each page it goes through. More details can be found here - http://www.seleniumhq.org/

Or you can write your own code to extract information, which can be run on your local computer or a server. I used this option. For honda city the URL wil look something like this - http://www.olx.in/nf/search/honda%2Bcity

Second page - http://www.olx.in/nf/search/honda%2Bcity/-p-2
Third page - http://www.olx.in/nf/search/honda%2Bcity/-p-3

You can run a loop to get as many pages as you want. In each page the data is presented in a very specific format which is easy to scrap.

I did not understand your second question fully. Once the data is there we can plot any kind of graphs from it.

Quote:
Originally Posted by 2000rpm View Post
Since they have counter measures to prevent this, I assume this is something they wanna protect and keep confidential.
Counter measures = Virtual Locks in my understanding, hence breaking a lock can open you to law suits
I am not sure of the laws and the technicality, would be good if you can explain the approach you followed to get the data.
I dont think there is any law that says I cant save information that they send to my browser. The counter measures they use are small tricks which will look at unusual activity from an IP address and block it for some time. So they were looking at the frequency of page requests from an IP and blocking it if it exceeded a certain level which is not possible by human beings. We wrote our code so that it waits for some time before sending request for more pages.

Moreover I am not selling their information or publishing it somewhere, I am only using it to draw inferences. Maybe they should do this on their site, it will attract a lot of traffic.
kenneyjacob is offline   (2) Thanks Reply With Quote
Old 22nd October 2014, 16:19   #19
Team-BHP Support
 
ampere's Avatar
 
Join Date: Sep 2009
Location: Bangalore
Posts: 15,604
Thanked: 8,594 Times
Default Re: Used Honda City - Year vs Price Analysis

Quote:
Originally Posted by kenneyjacob View Post
I did not understand your second question fully. Once the data is there we can plot any kind of graphs from it.
What I meant was :

- Plot curves for same year Price/Odo
- Plot curves for similar odo-bracket Price/Year

One gives an idea of reliability based re-sale while the other should provide idea on year based depreciation for the brand.
ampere is offline   Reply With Quote
Old 22nd October 2014, 17:33   #20
Newbie
 
Join Date: Jun 2014
Location: Trivandrum
Posts: 20
Thanked: 67 Times
Default Re: Used Honda City - Year vs Price Analysis

Quote:
Originally Posted by ampere View Post
- Plot curves for same year Price/Odo
- Plot curves for similar odo-bracket Price/Year
The following plots are for the honda city data. What can you infer from this ?
Attached Thumbnails
Used Honda City - Year vs Price Analysis-2010-honda-city.png  

Used Honda City - Year vs Price Analysis-2010-honda-city-odo-range.png  

kenneyjacob is offline   (2) Thanks Reply With Quote
Old 22nd October 2014, 21:01   #21
Team-BHP Support
 
ampere's Avatar
 
Join Date: Sep 2009
Location: Bangalore
Posts: 15,604
Thanked: 8,594 Times
Default Re: Used Honda City - Year vs Price Analysis

Quote:
Originally Posted by kenneyjacob View Post
The following plots are for the honda city data. What can you infer from this ?
On the first one, I can see that the cloud at least centered above 5L for the model. If we compare that across other cars, we should get a good idea about how others fare. As regards to the second one need to dig deeper.
ampere is offline   Reply With Quote
Old 23rd October 2014, 06:04   #22
Newbie
 
Join Date: Jun 2014
Location: Trivandrum
Posts: 20
Thanked: 67 Times
Default Re: Used Honda City - Year vs Price Analysis

Quote:
Originally Posted by ampere View Post
As regards to the second one need to dig deeper.
By looking at both these graphs is it safe to conclude that the age of the car has more impact on depreciation than the odometer reading ?
kenneyjacob is offline   (1) Thanks Reply With Quote
Old 23rd October 2014, 08:42   #23
Team-BHP Support
 
ampere's Avatar
 
Join Date: Sep 2009
Location: Bangalore
Posts: 15,604
Thanked: 8,594 Times
Default Re: Used Honda City - Year vs Price Analysis

Quote:
Originally Posted by kenneyjacob View Post
By looking at both these graphs is it safe to conclude that the age of the car has more impact on depreciation than the odometer reading ?
Surely. But I think if you compare the same chart against other cars, you may see a different trend. (I mean the same graph). Again please note even I am thinking aloud here.
ampere is offline   Reply With Quote
Old 27th October 2014, 12:55   #24
Senior - BHPian
 
alpha1's Avatar
 
Join Date: Apr 2007
Location: P00NA
Posts: 1,626
Thanked: 967 Times
Default Re: Used Honda City - Year vs Price Analysis

Quote:
Originally Posted by kenneyjacob View Post
By looking at both these graphs is it safe to conclude that the age of the car has more impact on depreciation than the odometer reading ?
Also that the km reading can fluctuate the asking price 1 Lac from the mean.

Of course the variants (top end vs low end) would also contribute to this fluctuation.
alpha1 is offline   Reply With Quote
Old 27th October 2014, 14:46   #25
Senior - BHPian
 
zenren's Avatar
 
Join Date: Oct 2008
Location: CLT/TVM/HYD
Posts: 2,576
Thanked: 1,723 Times
Default Re: Used Honda City - Year vs Price Analysis

Quote:
Originally Posted by kenneyjacob View Post
I dont think there is any law that says I cant save information that they send to my browser.
In this particular instance, you might be okay.

However, as a generic statement, it is incorrect. Unauthorized reproduction under copyright laws are even applicable in case you save content to your local machine that was intended only as viewable on their site. Classic example is the legal online streaming sites that show TV shows and movies (eg: Hulu) - Whether or not you intended to publish it later would be a very sensitive line that you might not be able to prove in case you land into some trouble.
zenren is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
City City Bang Bang! 1000 kms Report of my Honda City SMT roadie_swift Test-Drives & Initial Ownership Reports 39 4th June 2015 15:52
Fancy a half price Rolls Royce or half price Honda CRV? bigman The International Automotive Scene 37 15th October 2011 09:24
honda city v-tec plus (june 2008 launch) or new honda city (Oct 2008 launch)? nnandi Sedans 16 28th October 2008 17:03
Looking for advice on used honda city price ravi The Indian Car Scene 5 24th June 2004 01:24


All times are GMT +5.5. The time now is 18:08.

Copyright 2000 - 2017, Team-BHP.com
Proudly powered by E2E Networks