Interview Assessment
Download the above zip file and extract it Somewhere. After extracting, you must have found two excel files and a pdf. Refer PDF for your assessment.
Task1 :
Import the Excel File (Solar energy.xlsx) :
Clean the Data :
Let us clean empty rows and duplicate values if any.
Find Total Volume of the Articles:
We can use shape attribute to find total volume of the articles.
Find the total number of unique authors in the articles:
In how many articles is the word "solar" (case insensitive) mentioned?
Find the total number of articles each author has written:
We can groupby author names and count their body of the article.
Add 2 columns and extract the month and year from date :
Add another column and extract Domain from the URL:
Task 2:
Last updated