 Next we have Sameer, you are Sameer. Hi you people, am I audible? Yes you are audible and you have 5 minutes. Hello, I am audible and I am proceeding further. My topic is how I use Python in my CA office, that is Chartered Accountant office. We have three basic sites where we have to interact on a daily basis. First is the goods and service tax, second one is the Ministry of Corporate Affairs and third one is the income tax. On all of these three sites there is a lot of data that needs to be taken out. First of all let me just start off with how I used the GST site and Python. I tried to scrape the web data from the GST site and this is what I have tried to get it out from. First of all this is the data that comes in. We have a lot of data that needs to be taken out. First of all if this is a client of ours, we have to take out when exactly it has filed it and whether the data has been filed by them or not. So I have made a Python program which allows me to scrape this data. This is what is the site or what is the gist of my code. You can get it on my GitHub which is located here. This is where you will be able to get it and I will just demonstrate how this thing works in a minute. So say this is my site or on the right what you see is the name of the clients that I need to always scrape data for whether they have filed their returns on time or no and my program the VS code on the left actually runs and it is going to loop through each of these five clients and get the data when exactly they have filed or they have not filed. Please mind it with me that whatever they are filing it is very very important if there is any deadline that has been missed then they will lose a lot of money because they have to pay penalty and interest. So this is where I have used Python, I have used library like PyOpen Excel I have used PySimple GUI and Selenium to get this thing done and here you can see how it is happening. Python has been quite helpful in getting this data because physically it would not be possible to do it. Here I have done it only for five clients but I can do it even for 150 clients and it is platform independent, I don't need a separate software for this. This is one way of getting the data from the site and I found it quite useful. You can see the whole data of where they are registered where what all filings they have done, what is their officer is all possible to scrape it from the GSE site. Another way, and here at the end you can see the whole data has been downloaded into one neat Excel file and here it is. So this data is coming onto the Excel file. Other way I have used Python is by getting it from the ROC site. This is what my data is, this is what it looks like right now. So I have been able to get this thing and once in Excel I am very easily able to manipulate this data the way I want. The other way I have used Python in my office is by exploring the MCA site. Lately you might have heard of one company in India getting a lot of investment from foreign investors. If say this is the company, I want to find out on a daily basis what exactly the filings have been done by this entity. I can do so by actually having something called as view public documents which is available on this site. And I have made a Python program which allows me to download or at least get the names of the forms that have been filed on the site. So here let me just show you how this one is working. So right now what you see on the right side is actually the name of the company. On the left side is my Python VS code which is actually going to loop through what all data has been filed and in a minute you will be able to see how it is working. So for any company in India you have the name, the master details of the company the charges of the mortgage that has happened for the company and the list of directors for that company. My tool actually loops through all of this data and brings it into again a neat Excel file for it to be manipulated. This is for this very company and once I have downloaded all the data it makes my life easier or for my staff in this way it gets all the data. So what you see on the site is actually the company. Sameer we are out of time. So it loops through all of this and Python has helped me get to this point.