Categories: Visualizations

Browsing a tale of 5 cities

Reading Time: 4 mins

You can learn a lot about a city by the kind of activity it displays. In our case, we were interested in when a city wakes up – virtually.

Using data from a leading internet service provider, we looked at the time at which people log on to the Internet.

That’s the average browsing behaviour in 2011 across India. The darker blue indicate more people browsing online at that time. Most people seem to be browsing at 10pm (remember: this is primarily a domestic ISP), and there doesn’t seem to be a huge difference between the days, except that people wake up slightly later and sleep slightly later on Sundays.

However, between cities, there is a considerable variation in this pattern. Let’s compare Bangalore and Mumbai, for example.

The red areas indicate times when Bangalore-ans browse more, and blue areas indicate times when Mumbai-ites browse more. Folks from Bangalore are relatively early risers, starting as early as 4am on most days, and retain the lead until around 10am, when the Mumbai usage catches up. Mumbai leads in the afternoon, while Bangalore recaptures the lead a bit after 6pm. Most Bangalore-ans are asleep by 11pm, though, and Mumbai-ites zoom past, capturing the lion’s share of browsing between 11pm and 4am at night.

Also, it appears that Mumbai-ites work a lot less than Bangalore-ans on Sundays – opting to go online only after 9pm at night.

On the whole, “work-hard, play-hard” might capture the spirit of Mumbai-ites, while “early-to-rise” seems to define Bangalore. (From personal experience, we find that a bit hard to digest, but the data is irrefutable.)

A comparison with New Delhi shows a somewhat similar profile through the hours of the day, but the weekday behaviour is similar. So Bangalore does rise earlier and sleep earlier than New Delhi, but works about the same on weekdays and weekends.

In contrast, Bangalore and Chennai seem to have quite a similar browsing profile through the day. However, on weekends, Chennai seems to browse a lot less than Bangalore, thus qualifying as “early-to-rise”, and also for “relax-on-weekends”. (From personal experience, we find that quite believable.)

If we take Chennai and compare that with Mumbai or Delhi…

… the profiles are quite similar. As before, both cities wake up and sleep late. Mumbai is a bit more active on weekends than Delhi.

Just based on this data, if we summarise our experience, this is what it appears to be:

City Behaviour Rises early Rises late
Works on weekends Bangalore Mumbai
Takes weekends off Chennai New Delhi

The visualisation we used above is a heat-grid. It’s analogous to scatter plots, but for discrete data instead of continuous data. Some of the situations where we’ve used heat-grids include:

  • Plotting call volume in a call centre by date and hour
  • Plotting number of complaints by customer group and reason
  • Plotting training course expense by type of course and instructor
  • Plotting profitability by geography and branch type

… and so on.

If you’re interested in creating heat-grids yourself, you will find it fairly easy to do on Excel 2007 and beyond. Just fill in the values you want in, select them, and choose Conditional Formatting – Color Scales.

Update: We got requests to add a few cities – Hyderabad in particular. I’m afraid that this ISP does not have a strong presence in Hyderabad, so data is sparse. But here’s Pune:

As you can see, Pune seems to be a late riser. Probably not too different from Mumbai…

… and other than checking mails a bit earlier than Mumbai-ites on Sunday night, it’s pretty much the same pattern!

Gramener - A Straive Company

Gramener – A Straive company is a design-led data science firm. We build custom Data & Al solutions that help solve complex business problems with actionable insights and compelling data stories.

Leave a Comment
Share
Published by
Gramener - A Straive Company
Tags: Telecom

Recent Posts

Top 7 Benefits of Using AI for Quality Control in Manufacturing

AI in Manufacturing: Drastically Boosting Quality Control Imagine the factory floors are active with precision… Read More

2 days ago

10 Key Steps to Build a Smart Factory

Did you know the smart factory market is expected to grow significantly over the next… Read More

2 weeks ago

How to Future-Proof Warehouse Operations with Smart Inventory Management?

Effective inventory management is more crucial than ever in today's fast-paced business environment. It directly… Read More

1 month ago

Gramener Bags a Spot in AIM’s Top Data Science Service Providers 2024 Penetration-Maturity (PeMa) Quadrant

Gramener - A Straive Company has secured a spot in Analytics India Magazine’s (AIM) Challengers… Read More

3 months ago

Gramener Wins Nasscom AI Gamechangers 2024 Award for Responsible AI

Recently, we won the Nasscom AI Gamechangers Award for Responsible AI, especially for our Fish… Read More

4 months ago

Master Supply Chain Resilience: 5 Powerful Lessons from Our Location Intelligence Webinar

Supply chain disruptions can arise from various sources, such as extreme weather events, geopolitical tensions,… Read More

4 months ago

This website uses cookies.