In [47]:

%load_ext autoreload
%autoreload 2

The autoreload extension is already loaded. To reload it, use:
  %reload_ext autoreload

In [48]:

import pandas as pd
from happypred import whdata_to_csv

In [49]:

X_train_csv, y_train_csv, X_test_csv, y_test_csv = whdata_to_csv('WHR20_DataForTable2.1.xls')

In [50]:

X_train_csv

Out[50]:

'X_train.csv'

In [51]:

X_train_df = pd.read_csv(X_train_csv)
y_train_df = pd.read_csv(y_train_csv)

In [52]:

X_train_df

Out[52]:

	Log GDP per capita	Social support	Healthy life expectancy at birth	Freedom to make life choices	Generosity	Perceptions of corruption
0	7.144916	0.450662	50.799999	0.718114	0.178993	0.881686
1	7.314788	0.552308	51.200001	0.678896	0.201228	0.850035
2	7.421525	0.539075	51.599998	0.600127	0.131578	0.706766
3	7.394349	0.521104	51.919998	0.495901	0.173452	0.731109
4	7.480296	0.520637	52.240002	0.530935	0.246943	0.775620
...	...	...	...	...	...	...
1504	7.826639	0.765839	52.380001	0.642034	-0.067743	0.820217
1505	7.827643	0.735800	53.799999	0.667193	-0.117035	0.810457
1506	7.819675	0.768425	54.400002	0.732971	-0.088488	0.723612
1507	7.851042	0.754147	55.000000	0.752826	-0.091540	0.751208
1508	7.896704	0.775388	55.599998	0.762675	-0.063282	0.844209

1509 rows × 6 columns

In [ ]: