Pranjal K. Profile

EXPLOREAZĂ

5,0

(39 recenzii)

Acum urmărești pe

A apărut o eroare la urmărirea utilizatorului.

Utilizatorul nu le permite altor utilizatori să-l urmărească.

Urmărești deja acest utilizator.

Planul tău de abonament permite doar 0 urmăriri. Alege un abonament superior apăsând aici.

Nu mai urmărești pe

A apărut o eroare la anularea urmăririi utilizatorului.

Ai recomandat pe

A apărut o eroare la recomandarea utilizatorului.

A apărut o eroare. Reîncarcă pagina și încearcă din nou.

Adresa de e-mail a fost confirmată.

$35 USD/oră

mumbai,

india

$35 USD/oră

Momentan, aici e ora 1:12 p.m.

S-a înregistrat pe septembrie 26, 2018

0 Recomandări

Pranjal K.

@pranjalk2902

5,0

(39 recenzii)

5,4

83%

$35 USD/oră

mumbai,

india

$35 USD/oră

100 %

Proiecte finalizate

100 %

Conform bugetului

100 %

La timp

46 %

Rata de angajare repetată

Web Scraping and Excel Aficionado

I'm a professional web scraper and a VBA (Visual Basic for Applications) expert: - In the field of Web scraping I can scrape data from diverse kinds of websites into excel or any other mode as required, in Python and VBA. I have scraped/downloaded: ** Live Product Prices from commercial websites ** Live Scores, past results of matches from gaming websites ** Images, pdf files, videos or any other form of media into the user's computer ** Financial Statements of listed companies from database of Financial portals in Python and VBA - I am proficient in VBA and have a rich history of building varied range of utility programs in Excel to automate any repetitive task My main goal is to provide maximum value for your money and if you hire me you can rest assured of a 100% commitment to your project

Vezi toate opțiunile pentru Web Scraping Specialists din India

Discută cu Pranjal K. despre proiect

Conectează-te pentru a discuta pe chat despre detalii.

Portfoliu

The website: https://maharerait.mahaonline.gov.in/ is an authoritative website for accessing all Real Estate project details from any district in Maharashtra. Using this scraper I have scraped all 784 project record details of 'Maharashtra' State in 'Mumbai City' under 'Registered Projects' category which would otherwise have to be accessed by filling up several forms after navigating to the main URL mentioned above.
Using the scraper, a person could automate the entire form filling based on his inputs of 'State' (eg Maharashtra) and 'District' (eg Mumbai City within Maharashtra) and access all project detail records.
In the picture shared cells have been frozen from Row 3 onwards so that a person can see the last 784th record as well!

Maharashtra RERA Project Directory Scraper using Excel VBA

4965827

This excel file contains the Financial Statements of Procter & Gamble, the FMCG behemoth listed in US Stock Exchanges. The financial statements have been scraped from sec.gov;
In the pictures I have attached, one can clearly see, the 3 main FS: Balance Sheet, Income Statement and Cash Flow Statement of Procter & Gamble Inc scraped from sec.gov:
** This was a complex project wherein the financial statements had to be carefully searched from the sec.gov.in and various libraries in VBA had to be used to scrape and extract the desired information
** The information scraped includes the entire financial statements: Balance Sheet, Income Statement, Cash Flow Statement and ALL notes to Accounts - which is the main raw material that an analyst needs for making informed investment decisions

Financial Statements of P&G: A USA Listed Co using Excel VBA

This is a project in which I have provided functionality to scrape prices and web links of machine tools of various brands (mentioned in Column A) from 13 different commercial websites in 13 different worksheets. All the user has to do is press the button visible on the top left corner of the worksheet and obtain latest list of products along with their prices and web links whenever he needs it!
If he chooses to see a particular product's features in greater detail he simply needs to click on the link.
2 versions of this project have been implemented:
1) Using good old VBA
2) Using Python with it's excel libraries

German E-commerce Website Scraper using Excel VBA and Python

Just Dial is a leading Indian online business directory that contains an extensive database of business listings that users can access online from their website. Typical details including but not limited to names, addresses, phone numbers can be accessed based on relevant search criteria like location of business and type of business. In this project I have managed to scrape all 500 records for all Real Estate Agents in Mumbai city in India using Excel VBA. The important thing to note here is the phone number details which are not easily available and require designing of a special algorithm to be scraped.
To make sure you can see all 500 records I have frozen the rows up to the 8th row and then scrolled down till the last record. All one need do is click on the button and the scraper can pull all records from any given URL of justdial.com

justdial.com Business Directory Scraper using Excel VBA

Maharashtra RERA Project Directory Scraper using Excel VBA

4965827

Financial Statements of P&G: A USA Listed Co using Excel VBA

German E-commerce Website Scraper using Excel VBA and Python

justdial.com Business Directory Scraper using Excel VBA

Recenzii

Modificările au fost salvate

Se afișează 1 – 5 din 39 recenzii

Filtrează recenziile în funcție de:

5,0

$615,00 USD

Project for Pranjal K. -- 6

As always great co-operation and understanding project scope, fantastic professionalism of Pranjal, once again incredibly quick time of delivery completed projects and great communication skills, always a pleasure to work with Pranjal, he's one of the top freelancers on the platform!

+ încă 1