I am working on a Random Forest regression model to predict housing prices. I have about 500k rows of data with the following information:
1.House area in square meters.
2.Number of rooms.
6.The transaction date.
7.Type of house (single house, apartment building etc.)
8.The amount paid for the house.
I am planning on making a different model for each city, but I'm having trouble in representing the street name. I was thinking on using One Hot Encoder to represent the street name but some cities have over 1000 streets and that would give me over 1000 variables with moslty zero values.
I have read about sparse representation but I don't know how to use it in practice.
Let's say I already have a sparse representation of my data, how do I feed it to the Random Forest? Does the Random Forest Regressor from the sklearn library in Python support sparse data? If not, then is there another way to go about using Random Forest with sparse data in Python?