Question: 1 . Data Cleaning: ( a ) ( 2 pts ) How many companies are included in the Stocks.csv dataset? ( b ) ( 4

1. Data Cleaning:(a)(2pts) How many companies are included in the Stocks.csv dataset?(b)(4pts) How many missing values are there for each variable? How many in-complete observations are there?(c)(8pts) Clean up the missing data by either removing all incomplete observationsor by imputing values for the missing data. Which option did you choose?Why?(d)(2pts) Add a column to this dataset obtained by taking the log base 10 of thebook value.(e)(2pts) Add a column to this dataset obtained by taking the log base 10 of themarket cap.(f)(2pts) Add a column to this dataset obtained by taking the log base 10 of theEBITDA.(g)(4pts) Create a variable that is 1 if the company has a price-to-earnings ratiogreater than 12 and is O otherwise. Add this variable as a column in the dataset.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!