When I don’t have any recent projects to share I write about my past projects. And this one is just that: an analysis I did about two years (?) ago when I was learning the basics of Data analysis using Python.
I scraped the Top 100 buildings’ data off of SkyScraper.com using Import.io (Import.io was free once upon a time) and then performed some basic exploratory data analysis. Note that when I talk about tall buildings here, I am only talking about the top 100 buildings as per the 2015 data on SkyScraper.com.
Q. Which country has the highest number of tall buildings in top 100?
Q. Which city in China has the largest number of tall buildings?
A. Hong Kong
Q. Which city has the largest number of world’s tallest buildings?
The tallest building is Burj Khalifa whereas the 100th in the list is Ilham Baru Tower.
Q. What are the top 10 tallest buildings?
Out of the top 10 buildings, 3 are in China, 2 in USA and 2 in Malaysia.
Now let us look at their height.
Both of the towers in Malaysia have the same height. China has three towers of height 492, 484, and 450 m. USA has two towers of 541.3 and 442.1 m.
Let us see in which cities these top 10 towers lie.
As we can see there’s one tower in each city, except for Kuala Lumpur which has a twin tower.
Now let us bin all the buildings by the time when they were made. I’ve tried binning by the decade here.
We can see an increasing trend of taller buildings. Among the top 100 buildings, most were made after 2010.
Let us now see the construction of building in each country according to the decade.
In US, most of the tall buildings were made in 1980-1990 decade. China and UAE had most of their tall buildings built in 2010-2020.
The two buildings made before 1970 on the top 100 list both belong to US.
Let’s narrow down to the top 10 buildings.
None of the buildings made in 1980-1990 are in the top 10; one made in 1970 is in the top however.
Let us see which building it is.
Instead of all these binnings, we could have just plotted a histogram of the completed date to see the trend.Let us see all the dates as to when the buildings were completed.
The mean height of the buildings is 352 m.
Now let us look into the materials that were used in the buildings.
Among the top 100 buildings, the ones that were made in 1980s were only made up of steel.
The next thing to do is to see the tallest buildings from each country.
What about the number of floors?
The average number of floors seems to be 85.
Lets see the use of buildings by decade.
The buildings (in top 100), until 1990-2000, were not meant for residential purpose, but only for housing offices, and hotels.
Finally, lets see the height vs decade vs material used in construction.
Among the top 100 buildings, the ones that were made in 1980s used only steels. As the height increased, steel/concrete combination was used. Steels are still used for heights of ~300ish.
Thank you for reading! It was a bit long, but hopefully not as boring.
The codes for the analysis is available on my Github here.
No related posts.