Blackcoffer Consulting Website: https://blackcoffer.com | https://lsalead.com/ Web App Products: https://netclan.com/ | https://insights.blackcoffer.com/ | https://hirekingdom.com/ | https://workcroft.com/ Mobile App Products: Netclan | Bwstory
Data Extraction and NLP Test Assignment
Objective The objective of this assignment is to extract textual data articles from the given URL and perform text analysis to compute variables that are explained below.
Data Extraction Input.xlsx For each of the articles, given in the input.xlsx file, extract the article text and save the extracted article in a text file with URL_ID as its file name. While extracting text, please make sure your program extracts only the article title and the article text. It should not extract the website header, footer, or anything other than the article text.
NOTE: YOU MUST USE PYTHON PROGRAMMING TO EXTRACT DATA FROM THE URLs. YOU CAN USE BEATIFULSOUP, SELENIUM OR SCRAPY, OR ANY OTHER PYTHON LIBRARIES THAT YOU PREFER FOR DATA CRAWLING.
Data Analysis For each of the extracted texts from the article, perform textual analysis and compute variables, given in the output structure excel file. You need to save the output in the exact order as given in the output structure file, “Output Data Structure.xlsx” NOTE: YOU MUST USE PYTHON PROGRAMMING FOR THE DATA ANALYSIS
Variables Definition of each of the variables given in the “Text Analysis.docx” file. Look for these variables in the analysis document (Text Analysis.docx): POSITIVE SCORE NEGATIVE SCORE POLARITY SCORE SUBJECTIVITY SCORE AVG SENTENCE LENGTH PERCENTAGE OF COMPLEX WORDS FOG INDEX AVG NUMBER OF WORDS PER SENTENCE COMPLEX WORD COUNT WORD COUNT SYLLABLE PER WORD PERSONAL PRONOUNS AVG WORD LENGTH
Output Data Structure Output Variables: All input variables in “Input.xlsx” POSITIVE SCORE NEGATIVE SCORE POLARITY SCORE SUBJECTIVITY SCORE AVG SENTENCE LENGTH PERCENTAGE OF COMPLEX WORDS FOG INDEX AVG NUMBER OF WORDS PER SENTENCE COMPLEX WORD COUNT WORD COUNT SYLLABLE PER WORD PERSONAL PRONOUNS AVG WORD LENGTH Checkout output data structure spreadsheet for the format of your output, i.e. “Output Data Structure.xlsx”.
Timeline 6 days, sooner is better.
Where to submit To submit your solution, please fill this google sheet and upload your article to google drive, and share the drive url in the google sheet: https://forms.gle/nvWAgrCBdq1JkKou8
Make sure your submission contains: a) .py file b) output in csv or excel file as given in the output structure c) instructions