Hotly debated housing prices

On April 16, the National Bureau of Statistics released the housing price fluctuations in 70 large and medium-sized cities in March. Under the current background, the housing price in many cities is still running fast. For a time, the high housing price has become a hot topic again.

This is a big problem. As a data lover, I prefer to talk with data. Today, I’m going to talk about the housing prices of first-tier cities in Beijing, Shanghai, Guangzhou and Shenzhen.

Second-hand housing prices in first-tier cities

There are many websites related to housing price, such as 58.com, Anjuke and Homelink. Netizens all say that homelink has the highest credibility in housing price, so I crawled and collected nearly 30W second-hand housing information of Beijing, Shanghai, Guangzhou and Shenzhen on Homelink, and did some data analysis and visualization.

Let’s take a look at the overall distribution of the four cities.

Since high school, we have been told to pay attention to the x and Y axes when looking at the graph. At first glance, it looks like Guangzhou has the highest peak, but if you don’t pay attention, you might think that Guangzhou has the most expensive housing. In the figure above, X-axis represents the range of housing prices, and Y-axis represents the proportion of housing prices corresponding to X-axis in all housing prices. The curves of Beijing, Shanghai and Shenzhen almost coincide, as they are both short and fat. The X-axis coordinates corresponding to the peak values of Y-axis are relatively large, with most housing prices concentrated around 50000 and the maximum housing prices almost exceeding 150,000. At this point 150,000 accounted for about 0.000001, multiplied by the total number of dozens of w, multiplied by the width, sky-high housing is not a minority; In contrast, the curve of Guangzhou appears thin and high, a larger part of the housing price is concentrated around 25000, the difference between the maximum and minimum values is not so big, Guangzhou favorable +1+1+1.

This statistical description of housing prices in Beijing, Shanghai, Guangzhou and Shenzhen has verified our previous conclusion with specific figures, no matter in terms of the maximum, median and average of housing prices.

Now let’s focus on Beijing.

As can be seen from the area pie chart, more than 70% of second-hand houses in Beijing are located in the area of (40,120), which is also the choice of most families we see in life (no matter which city). There are more than 2% of the small houses, there are more than 10% of the 160 square meters of large apartment, visual inspection of three rooms and one hall starting, can be said to be very tuhao.

From the pie chart of building types, we can clearly see the proportion of various building types of second-hand housing in Beijing. Then the question comes: what is the slab floor and tower?

From Baidu Baike

Board building: generally, the number of building floors does not exceed 12. On the floor plan of the slab building, the length is obviously greater than the width. There are two types of slab building. The second is the unit splicing, a number of units connected together to form a board building. The biggest advantage of the board floor is the rules of the house, small mutual view, ventilation, good sunshine.

Tower: generally refers to high-rise buildings. Understand tower and slab from floor plan. The floor plan of the tower is characterized by a building plan of several households, usually more than four or five, surrounding or surrounding a group of public vertical transportation. The length and width of the floor plan are roughly the same. The height of the building ranges from 12 to 35 stories, and the 35 stories are super tall buildings. The appearance of the tower resembles that of a tower. The length and width of the plane are roughly the same. Generally, there are more than 6 households on the same floor of the tower. The simple description is that the building looks “slender”.

My understanding is that the board building is low in height and fewer floors, so the building density is low and the land utilization rate is low, so the housing price is high.

The tower is relatively high and the housing price is relatively low, but the water supply and power supply, elevator lighting and other conditions are relatively inferior to the board building.

In a word, tuhao live in board flat, not tuhao please go high.

Have you ever seen a villa with dozens of stories?

Take a look at Beijing zoning housing prices

Pay attention to the x axis is different districts in Beijing, and it is in accordance with the district center to distance from small to large, arranged in the center of xicheng district from the city recently, the highest prices, yanqing area far from downtown, house prices are almost the lowest, on the whole, the farther away from the central city, the lower the prices (probably not analysis can come out), so I again quantitative analysis.

After calculation, the slope of the fitting curve in the figure above is -862 yuan/km, that is to say, for every 1 km away from the center of Beijing, the second-hand housing price is about 862 YUAN cheaper. However, the housing price in the center of Beijing is touching high. The radius of the downtown of Beijing is about 30 km, according to the subtraction of 862 yuan per km, Some people have cut out of downtown Beijing to find or can not afford to buy a house, it is really too difficult.

What your friends think about house prices

As is known to all, Zhihu gathers elite people with high education and HIGH IQ to win.

Therefore, it is necessary for us to listen to these people’s views on the current housing price. For this, I have collected answers to five topics related to housing price on Zhihu, and collected the top 50 answers respectively, a total of 250 high-quality answers, and saved them in CSV.

I searched and looked again and again, and finally found several answers that reflected the level of Zhihu, which were really brilliant in literary style (in order to ensure the privacy of zhihu friends, no zhihu ID is attached, please forgive me).

On the day of China’s falling house prices, there is no forgetting to tell weng. By lu you. I take it you guys are having a match. Sitting up in a dying illness. Which neighborhood can fish bottom? On the day of China’s falling house prices, there is no forgetting to tell weng. By lu you. I take it you guys are having a match. Sitting up in a dying illness. Which neighborhood can fish bottom?

A fierce analysis as tiger, cheat zan drainage to the number of money, cool text read the palm drum, leek no room in the heart bitter; Diaosi also want to turn over, but wallet two hundred and thirty, evil real estate developers, I dwell in farmers’ houses; Salty fish also want to have a home, but no money to pay the down payment, girlfriend cheating on gao Shuai rich, but only the tube masturbation; Why do some zhihu experts like to write 5,000 words of lengthy analysis, citing various data, in order to argue that housing prices will fall, diaosi should not get on the bus.

Back to the topic, always feel that these crawl down to the text a little code analysis, without a word operation, Sir Into the word cloud.

The word cloud map should be removed, [is] [if] [can] [now] these irrelevant words, but, through these complicated appearance, we still clearly see the word cloud map clearly visible four big words: not falling.

It seems I agree with the global elite.