Indians are in every corner of the Globe, who wants to visit our corner?

In 2015 more than 20 mil­lion Indians trav­elled abroad. In the same year India’s di­a­spora pop­u­la­tion was the largest in the world with 16 mil­lion people from India liv­ing out­side their coun­try.

These two fig­ures made us curi­ous to find out who vis­its India. The avail­able cred­ible pub­lic in­form­a­tion came from, the ori­gin­al source be­ing Ministry of Home Affairs. We were able to ag­greg­ate count of India Visa is­sued across Indian Missions abroad by year/ month/ date. The time peri­od for which data was avail­able is July 2010 till January 2014. Note: The pub­lished data was miss­ing in­form­a­tion from 33 coun­tries with Indian Mission and 9 Visa Types.

Below are the in­sights gained af­ter feed­ing the ag­greg­ated data through the Data Explorer tool

  • 2013 was the year in which largest count of Visa was is­sued
  • Most for­eign na­tion­als ap­ply for Tourist Visa, fol­lowed by Business Visa.
  • In USA most of the Visa are is­sued in New York and San Francisco Missions and not Washington DC
  • Top 5 coun­tries where most Visas are is­sued – Bangladesh, United Kingdom, United States of America, Germany and Sri Lanka
  • Top 5 coun­tries where most Employment Visa, by count, are is­sued – Germany, Japan, United Kingdom, Korea and Australia.
  • Top 5 coun­tries where most Student Visa, by count, are is­sued – Nigeria, Bangladesh, Korea, Yemen and France
  • Top 5 coun­tries where most Missionary Visa, by count, are is­sued – USA, Armenia, Norway, Egypt and Kenya
  • Interestingly Pakistan is the only coun­try where Pilgrimage Visa were is­sued per avail­able data


  • Ministry of Tourism, Registrar General of India
  • UN Survey on International Migrant Trends
  • Ministry of Home Affairs

Data Wrangling: What, How and Why

Gramener’s CEO Anand and Senior Data Scientist Kathirmani along with the Upgrad team are run­ning a work­shop this Sunday (23 Oct, 11:30am) at Koramangala, Bangalore. The top­ic is “Data Wrangling – What, How and Why?”

Gramener's CEO Anand and Senior Data Scientist Kathirmani


Over 90% of data sci­ence is about clean­ing data – the pro­cess of load­ing, cor­rect­ing and pre­par­ing the data for ana­lys­is. This is a te­di­ous pro­cess. But what does it in­volve? What are the tricks of the trade? What tools and tech­niques make this easi­er?

Data is messy. (What a surpriise)
Data is messy. (If it sur­prises you, your ca­reer will be messy.)

Once we have the data ready, the toughest part is ask­ing the right ques­tions. Exploratory data ana­lys­is is about play­ing with data­sets in a struc­tured way to ex­tract as many of the im­port­ant in­sights as pos­sible in a given time. What are ef­fect­ive EDA tech­niques? Is there a struc­ture to this?

This talk is ideal for people in­ter­ested in learn­ing about data ana­lys­is, as well as ana­lysts who are look­ing to im­prove their data wrangling skills. Join us!