Show simple item record

dc.rights.licenseAll rights reserveden_US
dc.contributor.advisorDuffany, Jeffrey
dc.contributor.authorMartínez González, Luis F.
dc.date.accessioned2020-09-09T14:55:14Z
dc.date.available2020-09-09T14:55:14Z
dc.date.issued2016
dc.identifier.citationMartínez González, L.F. (2016). Automated data acquisition using microsoft excel [Unpublished manuscript]. Graduate School, Polytechnic University of Puerto Rico.en_US
dc.identifier.urihttp://hdl.handle.net/20.500.12475/530
dc.descriptionDesign Project Article for the Graduate Programs at Polytechnic University of Puerto Ricoen_US
dc.description.abstractThe process of Web Scraping allows the automated extraction of data from an entire website and turn it into a tabular dataset that can be used for reporting and analysis. There are numerous techniques and tools for web scraping and each one of them are better suited for certain scenarios. One of the most popular techniques, is the direct extraction of the data from the markup language within the website. That is the technique that will discussed in this paper and it will be put into practice by developing a tool using Microsoft Excel. For most individuals that regularly wok with data, Microsoft Excel is one of the most important and useful tools they can have when they need to do a quick analysis or visualize data. Microsoft Excel is powered by an extensible framework and that is Visual Basic for Applications, which allows the implementation of robust functionalities in a tool. In this paper, it will be combined the power of Microsoft Excel and its underlying features, and a popular Web Scraping technique to automate the process of web data acquisition and have this data ready to be processed in Microsoft Excel. Key Terms - Data Automation, Microsoft Excel, Web Programming, Web Scraping.en_US
dc.language.isoen_USen_US
dc.publisherPolytechnic University of Puerto Ricoen_US
dc.relation.ispartofComputer Science;
dc.relation.ispartofseriesSpring-2016;
dc.relation.haspartSan Juanen_US
dc.subject.lcshMicrosoft software
dc.subject.lcshScrapers (Tools)
dc.subject.lcshPolytechnic University of Puerto Rico--Graduate students--Research
dc.titleAutomated Data Acquisition using Microsoft Excelen_US
dc.typeArticleen_US
dc.rights.holderPolytechnic University of Puerto Rico, Graduate Schoolen_US


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record