Answer to Question #294305 in Python for suresh

Question

Stock_File_1’, a stock trend forecasting company has just employed you as a Data Scientist. As a first task in your new job, your manager has provided you with a company’s stock data and asked you to check the quality of the data for the next step of analysis. Following are the additional description and information about the data which your manager has shared with you.

a)     The data set contains six variables namely-

                                                      i.     Date

                                                    ii.     Open

                                                  iii.     High

                                                  iv.     Low

                                                    v.     Close

                                                  vi.     Volume

Answer 1

import pandas as pd

df = pd.read_csv('survey_results_public.csv')
df.head()

df.shape
(88883, 85)

df['BetterLife'].value_counts()

Yes    54938
No     31331
Name: BetterLife, dtype: int64
df['BetterLife'].value_counts(normalize=True)

Yes    0.636822
No     0.363178
Name: BetterLife, dtype: float64
df['MgrMoney'].value_counts(normalize=True)
No          0.512550
Yes         0.291528
Not sure    0.195922
Name: MgrMoney, dtype: float64