In [1]:
from __future__ import print_function
import numpy as np
import pandas as pd
import matplotlib.pylab as plt
from collections import OrderedDict
%matplotlib inline
#pd.options.display.mpl_style = 'default'
#pd.options.display.max_columns = 30
#pd.options.display.max_rows = 40
input_scales_csv = "RS2_QD_20141028a.csv"
In [15]:
# using this for inline documentation so that it's clear
# that the printing statement isn't part of the necessary
# transformation code.
def html_print(df):
from IPython.display import HTML
try:
out = df.to_html()
except AttributeError:
out = pd.DataFrame(df).to_html()
return HTML(out)
def htmljoin(df_list, delimiter=''):
from IPython.display import HTML
return HTML(delimiter.join([x.to_html() for x in df_list]))
def col_matches(df, regex):
import re
cols = list(enumerate(df.columns))
matches = [c for (i, c) in cols
if re.findall(regex, c)]
return matches
def concat_matches(df, *args):
assert all([len(r) for r in args])
import re
col_match_lists = [col_matches(df, regex) for regex in args]
col_set = [df[matches] for matches in col_match_lists]
if len(col_set) == 0:
return None
elif len(col_set) == 1:
return col_set[0]
else:
return pd.concat(col_set, axis=1)
def show_frames(frame_list, delimiter=''):
from IPython.display import HTML
if len(frame_list) == len(delimiter):
html_out = ""
item_template = '<p><strong>{}</strong></p>{}<br>'
for i, tup in enumerate(zip(frame_list, delimiter)):
frame = tup[0]
tag = tup[1]
html_out += item_template.format(tag, frame.to_html())
return HTML(html_out)
else:
html_out = [df.to_html() for df in frame_list]
return HTML(delimiter.join(html_out))
def compare_transformations(df, columns, functions, **kwargs):
print('raw')
df[columns].hist(**kwargs)
plt.show()
for name, func in functions.items():
print(name)
df[columns].apply(func).hist(**kwargs)
plt.show()
def quickcompare(r, size=(15,7)):
return compare_transformations(dfo, col_matches(dfo, r),
{'log1p': np.log1p,
'sqrt': np.sqrt, },
figsize=size)
In [3]:
dfo = pd.read_csv(input_scales_csv,
index_col='pid',
)
def add_leading_zeroes(pid):
no_leading_zero = str(pid)
with_leading_zeroes = '000'[len(no_leading_zero):] + no_leading_zero
return with_leading_zeroes
dfo.index = dfo.reset_index('pid').pid.apply(add_leading_zeroes)
dfo[::12].T.head()
Out[3]:
pid
015
028
041
056
068
081
094
107
119
session_day
20140228
20140305
20140326
20140408
20140414
20140423
20140501
20140506
20140509
session_time
1:00pm
3:40pm
1:00pm
11:00am
12:00nn
2:50pm
7:35am
12:00nn
3:00pm
session_isfemale
1
0
1
0
1
0
1
0
1
sex_femalezero
0
1
0
1
0
1
0
1
0
participant_age
21
18
23
21
19
20
22
20
19
In [4]:
#show missing values from original CSV entry ('77777')
html_print(dfo.loc['053'].head(10)) #example P with missing WASI subtest
Out[4]:
053
session_day
20140407
session_time
12:00nn
session_isfemale
1
sex_femalezero
0
participant_age
20
calc_wasivocab_totalrawscore
44
calc_wasimatrix_totalscore
77777
calc_wasivocab_tscore
61
calc_wasimatrix_tscore
77777
calc_wasi_tscore_total
77777
In [5]:
# Replace NaNs in note-taking columns with blanks for readability
def note_columns():
note_columns = col_matches(dfo, "notes")
assert len(note_columns) == 25
more_note_columns = ['qbasic_ethnicityother',
'qmusic_dancestyle',
'qmusic_drumstyles',
'qmusic_instrumentlist',
'qmusic_gamenames']
assert set(more_note_columns).issubset(dfo.columns)
note_columns += more_note_columns
assert len(note_columns) == 30
return note_columns
dfo.loc[:, note_columns()] = dfo.loc[:, note_columns()].fillna("")
# Replace missing data (coded "77777") with NaNs
# (but will change this back before exporting for external analyses)
dfo.replace('77777', np.nan, inplace=True)
html_print(dfo[30:40].T[18:22])
Out[5]:
pid
049
051
052
053
054
055
056
057
058
059
order_500ms_first
1
0
1
1
1
1
1
1
1
1
order_rhythmfirst
0
1
0
1
0
0
1
0
0
0
notes_csv_cleaning
reset machine during ticks-linear-500, right w...
(1) Data for 054 has ID #055's first practice ...
first practice task's data is in the previous ...
notes_adminerror
Matrix reasoning not completed (apparently for...
In [6]:
# View missing values
htmljoin([pd.DataFrame(row[row.isnull()])[:7].T
for i, row in dfo.iterrows()
if len(row[row.isnull()]) > 0])
Out[6]:
qmusic_dancehours
043
NaN
calc_wasimatrix_totalscore
calc_wasimatrix_tscore
calc_wasi_tscore_total
calc_fsiq2
wasimatrix_itemscore01
wasimatrix_itemscore02
wasimatrix_itemscore03
053
NaN
NaN
NaN
NaN
NaN
NaN
NaN
qmusic_dancehours
054
NaN
qbasic_handednessa
qbasic_handednessb
qbasic_handednessc
qbasic_handednessd
qbasic_handednesse
055
NaN
NaN
NaN
NaN
NaN
qbasic_relationshipyears
qbasic_relationshipmonths
calc_qbasic_rel_totalmonths
qmusic_singinghours
qmusic_singingtimes
qmusic_drumhours
qmusic_drumlevel
064
NaN
NaN
NaN
NaN
NaN
NaN
NaN
qmusic_singingtimes
066
NaN
qmusic_behaviors_07_yourself
093
NaN
qbasic_totalheightin
109
NaN
qbasic_handednessc
110
NaN
bfi_item24
121
NaN
In [8]:
simple_hour_items = col_matches(dfo, 'hours$') # '$' --> matches only end of name
simple_hour_items
Out[8]:
['qmusic_singinghours',
'qmusic_dancehours',
'qmusic_instrumenthours',
'qmusic_drumhours']
In [9]:
# Extreme floor effect for "practice hours" items when viewing
# the overall sample, so:
# Zero or nonzero monthly practice hours?
hour_counts_A = ['qmusic_singinghours',
'qmusic_singingtimes',
'qmusic_dancehours',
'qmusic_instrumenthours',
'qmusic_drumhours',
'qmusic_behaviors_09_danceprv',
'qmusic_behaviors_10_dancepub',
'qmusic_gamehoursall',
'qmusic_gamehoursdrumsticks',
]
for varname in hour_counts_A:
s = dfo[varname]
is_nonzero = (s > 0) # --> False, True
dfo[varname + '_nonzero'] = is_nonzero.astype(int) # --> 0, 1
In [12]:
#pleasant matplotlib style set by pandas library
pd.options.display.mpl_style = 'default'
print('raw distributions:')
dfo[hour_counts_A].hist(figsize=(10,10))
plt.show()
print(concat_matches(dfo, '_nonzero$').head(4).T)
raw distributions:
pid 015 016 017 018
qmusic_singinghours_nonzero 1 0 0 0
qmusic_singingtimes_nonzero 0 0 0 0
qmusic_dancehours_nonzero 1 1 0 1
qmusic_instrumenthours_nonzero 0 0 0 0
qmusic_drumhours_nonzero 0 0 0 0
qmusic_behaviors_09_danceprv_nonzero 1 1 0 1
qmusic_behaviors_10_dancepub_nonzero 0 1 0 1
qmusic_gamehoursall_nonzero 1 0 0 0
qmusic_gamehoursdrumsticks_nonzero 0 0 0 0
In [ ]:
pos_skewed_vars = ['qmusic_behaviors_07_yourself',
'qmusic_behaviors_08_otherprs',
'qmusic_behaviors_09_danceprv',
'qmusic_dancelevel']
In [40]:
compare_transformations(dfo, pos_skewed_vars,
{'log1p': np.log1p,
'sqrt': np.sqrt,},
figsize=(15,7))
raw
log1p
sqrt
In [ ]:
for varname in pos_skewed_vars:
s = dfo[varname]
dfo[varname + '_ln1p'] = np.log1p(s) #ln of (x + 1)
In [38]:
from functools import partial
medsplit = partial(pd.qcut, q=2, labels=False)
compare_transformations(dfo,
['qmusic_dancelevel'],
{'medsplit': medsplit},
figsize=(10,3))
raw
medsplit
In [39]:
dfo['qmusic_dancelevel_tophalf'] = medsplit(dfo['qmusic_dancelevel'])
# same as recoding as (0-1) --> 0
# (2-7) --> 1
In [41]:
compare_transformations(dfo,
col_matches(dfo, 'rel_totalmonths'),
{'log1p': np.log1p,
'sqrt': np.sqrt, },
figsize=(10,3))
raw
log1p
sqrt
In [42]:
quickcompare('times$', size=(5,3))
raw
log1p
sqrt
In [49]:
#zero-indexed order of tasks of this ISI among the two types
dfo['orders_500'] = 1 - dfo.order_500ms_first
dfo['orders_800'] = 0 + dfo.order_500ms_first
# entered as strings in session_taskorder:
# 1. Iso, Lin, Phase
# 2. Iso, Phase, Lin
# 3. Lin, Iso, Phase
# 4. Lin, Phase, Iso
# 5. Phase, Iso, Lin
# 6. Phase, Lin, Iso
# first character (number indicating overall order)
order_n = dfo['session_taskorder'].apply(lambda x: int(x[0]))
#zero-indexed order of tasks of this type among the three types
isochronous_placement = {1: 0, 2: 0, 3: 1,
4: 2, 5: 1, 6: 2,}
phaseshift_placement = {1: 2, 2: 1, 3: 2,
4: 1, 5: 0, 6: 0,}
linearchange_placement = {1: 1, 2: 2, 3: 0,
4: 0, 5: 2, 6: 1,}
dfo['orders_iso'] = order_n.apply(lambda x: isochronous_placement[x])
dfo['orders_phase'] = order_n.apply(lambda x: phaseshift_placement[x])
dfo['orders_linear'] = order_n.apply(lambda x: linearchange_placement[x])
dfo['orderc_iso_before_lin'] = (dfo.orders_iso < dfo.orders_linear).astype(int)
dfo['orderc_iso_before_phase'] = (dfo.orders_iso < dfo.orders_phase).astype(int)
dfo['orderc_phase_before_lin'] = (dfo.orders_phase < dfo.orders_linear).astype(int)
# Set up precice ordering of each task in the set (1-indexed)
# practice trials of isochronous/single-stimulus
dfo['order_iso5t1'] = dfo.orders_500 + 1
dfo['order_iso8t1'] = dfo.orders_800 + 1
# +1 to set from zero-indexed to one-indexed,
# then +2 because the the first two have passed (iso5t1 and iso5t2)
dfo['order_iso5t2'] = 2 + (2 * dfo.orders_iso) + dfo.orders_500 + 1
dfo['order_iso8t2'] = 2 + (2 * dfo.orders_iso) + dfo.orders_800 + 1
dfo['order_psh5t'] = 2 + (2 * dfo.orders_phase) + dfo.orders_500 + 1
dfo['order_psh8t'] = 2 + (2 * dfo.orders_phase) + dfo.orders_800 + 1
dfo['order_lin5t'] = 2 + (2 * dfo.orders_linear) + dfo.orders_500 + 1
dfo['order_lin8t'] = 2 + (2 * dfo.orders_linear) + dfo.orders_800 + 1
dfo['order_iso5j'] = 6 + dfo['order_iso5t2'] #already adjusted to 1-index
dfo['order_iso8j'] = 6 + dfo['order_iso8t2']
dfo['order_psh5j'] = 6 + dfo['order_psh5t']
dfo['order_psh8j'] = 6 + dfo['order_psh8t']
dfo['order_lin5j'] = 6 + dfo['order_lin5t']
dfo['order_lin8j'] = 6 + dfo['order_lin8t']
dfo['order_isip5'] = dfo['order_iso5t1'] + 2 + 6 + 6
dfo['order_isip8'] = dfo['order_iso8t1'] + 2 + 6 + 6
html_print(concat_matches(dfo, '^order|taskorder')[::20].T.sort())
Out[49]:
pid
015
037
060
081
102
order_500ms_first
0
0
0
0
1
order_isip5
16
16
16
16
15
order_isip8
15
15
15
15
16
order_iso5j
12
14
14
10
13
order_iso5t1
2
2
2
2
1
order_iso5t2
6
8
8
4
7
order_iso8j
11
13
13
9
14
order_iso8t1
1
1
1
1
2
order_iso8t2
5
7
7
3
8
order_lin5j
10
10
10
14
11
order_lin5t
4
4
4
8
5
order_lin8j
9
9
9
13
12
order_lin8t
3
3
3
7
6
order_psh5j
14
12
12
12
9
order_psh5t
8
6
6
6
3
order_psh8j
13
11
11
11
10
order_psh8t
7
5
5
5
4
order_rhythmfirst
0
0
0
0
1
orderc_iso_before_lin
0
0
0
1
0
orderc_iso_before_phase
1
0
0
1
0
orderc_phase_before_lin
0
0
0
1
1
orders_500
1
1
1
1
0
orders_800
0
0
0
0
1
orders_iso
1
2
2
0
2
orders_linear
0
0
0
2
1
orders_phase
2
1
1
1
0
session_taskorder
3. Lin, Iso, Phase
4. Lin, Phase, Iso
4. Lin, Phase, Iso
2. Iso, Phase, Lin
6. Phase, Lin, Iso
In [50]:
#Looking at high-end outliers, no transformations done here
hours_col_names = col_matches(dfo, 'hours')
hours_col_names += col_matches(dfo, 'behaviors_07')
hours_col_names += col_matches(dfo, 'behaviors_08')
hours_col_names += col_matches(dfo, 'behaviors_09')
hours_col_names += col_matches(dfo, 'behaviors_10')
hours_cols = dfo[hours_col_names]
frames = [hours_cols.sort(c, ascending=False).head(8).T
for c in hours_cols.columns]
show_frames(frames, hours_col_names)
#log_hours_columns = np.log1p(hours_cols)
#log_hours_columns.sort(col)
Out[50]:
qmusic_singinghours
pid
075
041
033
066
078
056
110
107
qmusic_singinghours
60.000000
55.000000
30.000000
30.000000
27.000000
20.000000
20.000000
17.500000
qmusic_dancehours
0.000000
2.000000
4.000000
16.000000
6.000000
0.000000
0.000000
0.000000
qmusic_instrumenthours
24.000000
8.000000
70.000000
60.000000
28.000000
20.000000
30.000000
5.000000
qmusic_gamehoursall
2.000000
0.000000
0.000000
20.000000
3.000000
20.000000
0.000000
60.000000
qmusic_gamehoursdrumsticks
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_drumhours
30.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_dancehours_nonzero
0.000000
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
0.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_drumhours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
0.000000
0.000000
1.000000
1.000000
1.000000
0.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
12.500000
15.000000
7.000000
42.000000
8.000000
100.000000
8.000000
35.000000
qmusic_behaviors_07_yourself_ln1p
2.602690
2.772589
2.079442
3.761200
2.197225
4.615121
2.197225
3.583519
qmusic_behaviors_08_otherprs
6.000000
4.500000
21.000000
20.000000
3.000000
72.000000
2.000000
2.000000
qmusic_behaviors_08_otherprs_ln1p
1.945910
1.704748
3.091042
3.044522
1.386294
4.290459
1.098612
1.098612
qmusic_behaviors_09_danceprv
2.000000
3.500000
0.000000
0.000000
3.000000
24.000000
0.000000
0.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
1.000000
0.000000
0.000000
1.000000
1.000000
0.000000
0.000000
qmusic_behaviors_09_danceprv_ln1p
1.098612
1.504077
0.000000
0.000000
1.386294
3.218876
0.000000
0.000000
qmusic_behaviors_10_dancepub
1.000000
5.000000
3.000000
0.000000
1.000000
10.000000
0.000000
0.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
1.000000
0.000000
1.000000
1.000000
0.000000
0.000000
qmusic_dancehours
pid
119
019
098
060
044
118
015
053
qmusic_singinghours
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
5.000000
5.000000
qmusic_dancehours
60.000000
50.000000
30.000000
30.000000
25.000000
24.000000
20.000000
20.000000
qmusic_instrumenthours
250.000000
5.000000
8.000000
2.000000
0.000000
20.000000
0.000000
1.000000
qmusic_gamehoursall
10.000000
10.000000
2.000000
1.000000
15.000000
0.000000
5.000000
0.000000
qmusic_gamehoursdrumsticks
10.000000
1.000000
0.000000
1.000000
1.000000
0.000000
0.000000
0.000000
qmusic_drumhours
200.000000
0.000000
0.000000
3.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
1.000000
qmusic_dancehours_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
0.000000
1.000000
qmusic_drumhours_nonzero
1.000000
0.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
0.000000
qmusic_gamehoursdrumsticks_nonzero
1.000000
1.000000
0.000000
1.000000
1.000000
0.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
72.000000
10.000000
40.000000
5.000000
24.000000
20.000000
14.000000
15.000000
qmusic_behaviors_07_yourself_ln1p
4.290459
2.397895
3.713572
1.791759
3.218876
3.044522
2.708050
2.772589
qmusic_behaviors_08_otherprs
80.000000
5.000000
2.000000
5.000000
5.000000
20.000000
10.000000
10.000000
qmusic_behaviors_08_otherprs_ln1p
4.394449
1.791759
1.098612
1.791759
1.791759
3.044522
2.397895
2.397895
qmusic_behaviors_09_danceprv
0.000000
30.000000
25.000000
1.000000
15.000000
0.000000
5.000000
10.000000
qmusic_behaviors_09_danceprv_nonzero
0.000000
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
0.000000
3.433987
3.258097
0.693147
2.772589
0.000000
1.791759
2.397895
qmusic_behaviors_10_dancepub
10.000000
24.000000
5.000000
6.000000
10.000000
5.000000
0.000000
3.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
qmusic_instrumenthours
pid
119
033
066
052
032
110
115
078
qmusic_singinghours
0.000000
30.000000
30.000000
15.000000
10.000000
20.000000
10.000000
27.000000
qmusic_dancehours
60.000000
4.000000
16.000000
0.000000
2.000000
0.000000
5.000000
6.000000
qmusic_instrumenthours
250.000000
70.000000
60.000000
42.000000
40.000000
30.000000
30.000000
28.000000
qmusic_gamehoursall
10.000000
0.000000
20.000000
0.000000
0.000000
0.000000
0.000000
3.000000
qmusic_gamehoursdrumsticks
10.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_drumhours
200.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_dancehours_nonzero
1.000000
1.000000
1.000000
0.000000
1.000000
0.000000
1.000000
1.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_drumhours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
72.000000
7.000000
42.000000
13.000000
50.000000
8.000000
10.000000
8.000000
qmusic_behaviors_07_yourself_ln1p
4.290459
2.079442
3.761200
2.639057
3.931826
2.197225
2.397895
2.197225
qmusic_behaviors_08_otherprs
80.000000
21.000000
20.000000
0.500000
0.000000
2.000000
14.000000
3.000000
qmusic_behaviors_08_otherprs_ln1p
4.394449
3.091042
3.044522
0.405465
0.000000
1.098612
2.708050
1.386294
qmusic_behaviors_09_danceprv
0.000000
0.000000
0.000000
0.000000
20.000000
0.000000
2.000000
3.000000
qmusic_behaviors_09_danceprv_nonzero
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
0.000000
0.000000
0.000000
0.000000
3.044522
0.000000
1.098612
1.386294
qmusic_behaviors_10_dancepub
10.000000
3.000000
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
qmusic_gamehoursall
pid
036
107
025
066
056
086
044
119
qmusic_singinghours
0.000000
17.500000
0.000000
30.000000
20.000000
0.000000
0.000000
0.000000
qmusic_dancehours
0.000000
0.000000
8.000000
16.000000
0.000000
16.000000
25.000000
60.000000
qmusic_instrumenthours
0.000000
5.000000
0.000000
60.000000
20.000000
8.000000
0.000000
250.000000
qmusic_gamehoursall
240.000000
60.000000
28.000000
20.000000
20.000000
18.000000
15.000000
10.000000
qmusic_gamehoursdrumsticks
0.000000
0.000000
4.000000
0.000000
0.000000
5.000000
1.000000
10.000000
qmusic_drumhours
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
200.000000
qmusic_singinghours_nonzero
0.000000
1.000000
0.000000
1.000000
1.000000
0.000000
0.000000
0.000000
qmusic_dancehours_nonzero
0.000000
0.000000
1.000000
1.000000
0.000000
1.000000
1.000000
1.000000
qmusic_instrumenthours_nonzero
0.000000
1.000000
0.000000
1.000000
1.000000
1.000000
0.000000
1.000000
qmusic_drumhours_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
0.000000
1.000000
0.000000
0.000000
1.000000
1.000000
1.000000
qmusic_behaviors_07_yourself
40.000000
35.000000
6.000000
42.000000
100.000000
12.000000
24.000000
72.000000
qmusic_behaviors_07_yourself_ln1p
3.713572
3.583519
1.945910
3.761200
4.615121
2.564949
3.218876
4.290459
qmusic_behaviors_08_otherprs
10.000000
2.000000
1.000000
20.000000
72.000000
0.000000
5.000000
80.000000
qmusic_behaviors_08_otherprs_ln1p
2.397895
1.098612
0.693147
3.044522
4.290459
0.000000
1.791759
4.394449
qmusic_behaviors_09_danceprv
30.000000
0.000000
0.000000
0.000000
24.000000
4.000000
15.000000
0.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
0.000000
0.000000
0.000000
1.000000
1.000000
1.000000
0.000000
qmusic_behaviors_09_danceprv_ln1p
3.433987
0.000000
0.000000
0.000000
3.218876
1.609438
2.772589
0.000000
qmusic_behaviors_10_dancepub
0.000000
0.000000
8.000000
0.000000
10.000000
2.000000
10.000000
10.000000
qmusic_behaviors_10_dancepub_nonzero
0.000000
0.000000
1.000000
0.000000
1.000000
1.000000
1.000000
1.000000
qmusic_gamehoursdrumsticks
pid
119
086
024
027
025
047
101
034
qmusic_singinghours
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours
60.000000
16.000000
5.000000
0.000000
8.000000
0.000000
1.000000
0.000000
qmusic_instrumenthours
250.000000
8.000000
0.000000
0.000000
0.000000
4.000000
1.000000
7.000000
qmusic_gamehoursall
10.000000
18.000000
10.000000
5.000000
28.000000
3.000000
1.000000
0.000000
qmusic_gamehoursdrumsticks
10.000000
5.000000
5.000000
5.000000
4.000000
2.000000
1.000000
1.000000
qmusic_drumhours
200.000000
0.000000
0.000000
0.000000
0.000000
2.000000
0.000000
0.500000
qmusic_singinghours_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours_nonzero
1.000000
1.000000
1.000000
0.000000
1.000000
0.000000
1.000000
0.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
0.000000
0.000000
0.000000
1.000000
1.000000
1.000000
qmusic_drumhours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
1.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
qmusic_gamehoursdrumsticks_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_07_yourself
72.000000
12.000000
50.000000
12.000000
6.000000
5.500000
14.000000
3.500000
qmusic_behaviors_07_yourself_ln1p
4.290459
2.564949
3.931826
2.564949
1.945910
1.871802
2.708050
1.504077
qmusic_behaviors_08_otherprs
80.000000
0.000000
10.000000
4.000000
1.000000
1.500000
1.000000
1.500000
qmusic_behaviors_08_otherprs_ln1p
4.394449
0.000000
2.397895
1.609438
0.693147
0.916291
0.693147
0.916291
qmusic_behaviors_09_danceprv
0.000000
4.000000
15.000000
0.000000
0.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_nonzero
0.000000
1.000000
1.000000
0.000000
0.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
0.000000
1.609438
2.772589
0.000000
0.000000
0.693147
0.693147
0.693147
qmusic_behaviors_10_dancepub
10.000000
2.000000
5.000000
0.000000
8.000000
40.000000
1.000000
0.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
1.000000
0.000000
1.000000
1.000000
1.000000
0.000000
qmusic_drumhours
pid
119
075
113
060
047
034
085
094
qmusic_singinghours
0.000000
60.000000
9.500000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours
60.000000
0.000000
0.000000
30.000000
0.000000
0.000000
0.500000
0.000000
qmusic_instrumenthours
250.000000
24.000000
20.000000
2.000000
4.000000
7.000000
0.500000
0.000000
qmusic_gamehoursall
10.000000
2.000000
2.000000
1.000000
3.000000
0.000000
0.000000
0.000000
qmusic_gamehoursdrumsticks
10.000000
0.000000
1.000000
1.000000
2.000000
1.000000
0.000000
0.000000
qmusic_drumhours
200.000000
30.000000
5.500000
3.000000
2.000000
0.500000
0.000000
0.000000
qmusic_singinghours_nonzero
0.000000
1.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours_nonzero
1.000000
0.000000
0.000000
1.000000
0.000000
0.000000
1.000000
0.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
qmusic_drumhours_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
0.000000
qmusic_gamehoursdrumsticks_nonzero
1.000000
0.000000
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
72.000000
12.500000
6.000000
5.000000
5.500000
3.500000
2.000000
12.000000
qmusic_behaviors_07_yourself_ln1p
4.290459
2.602690
1.945910
1.791759
1.871802
1.504077
1.098612
2.564949
qmusic_behaviors_08_otherprs
80.000000
6.000000
2.000000
5.000000
1.500000
1.500000
1.000000
5.000000
qmusic_behaviors_08_otherprs_ln1p
4.394449
1.945910
1.098612
1.791759
0.916291
0.916291
0.693147
1.791759
qmusic_behaviors_09_danceprv
0.000000
2.000000
0.000000
1.000000
1.000000
1.000000
0.000000
3.000000
qmusic_behaviors_09_danceprv_nonzero
0.000000
1.000000
0.000000
1.000000
1.000000
1.000000
0.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
0.000000
1.098612
0.000000
0.693147
0.693147
0.693147
0.000000
1.386294
qmusic_behaviors_10_dancepub
10.000000
1.000000
0.000000
6.000000
40.000000
0.000000
0.000000
6.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
0.000000
1.000000
1.000000
0.000000
0.000000
1.000000
qmusic_singinghours_nonzero
pid
015
033
078
082
067
066
087
061
qmusic_singinghours
5.000000
30.000000
27.000000
13.000000
5.00000
30.000000
2.000000
2.000000
qmusic_dancehours
20.000000
4.000000
6.000000
1.000000
3.00000
16.000000
0.000000
5.000000
qmusic_instrumenthours
0.000000
70.000000
28.000000
0.000000
10.00000
60.000000
0.000000
1.000000
qmusic_gamehoursall
5.000000
0.000000
3.000000
1.000000
0.00000
20.000000
1.000000
2.500000
qmusic_gamehoursdrumsticks
0.000000
0.000000
0.000000
0.000000
0.00000
0.000000
0.000000
0.000000
qmusic_drumhours
0.000000
0.000000
0.000000
0.000000
0.00000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
1.000000
1.000000
1.000000
1.000000
1.00000
1.000000
1.000000
1.000000
qmusic_dancehours_nonzero
1.000000
1.000000
1.000000
1.000000
1.00000
1.000000
0.000000
1.000000
qmusic_instrumenthours_nonzero
0.000000
1.000000
1.000000
0.000000
1.00000
1.000000
0.000000
1.000000
qmusic_drumhours_nonzero
0.000000
0.000000
0.000000
0.000000
0.00000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
0.000000
1.000000
1.000000
0.00000
1.000000
1.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
0.000000
0.000000
0.000000
0.00000
0.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
14.000000
7.000000
8.000000
40.000000
6.00000
42.000000
17.000000
1.000000
qmusic_behaviors_07_yourself_ln1p
2.708050
2.079442
2.197225
3.713572
1.94591
3.761200
2.890372
0.693147
qmusic_behaviors_08_otherprs
10.000000
21.000000
3.000000
2.000000
6.00000
20.000000
5.000000
1.000000
qmusic_behaviors_08_otherprs_ln1p
2.397895
3.091042
1.386294
1.098612
1.94591
3.044522
1.791759
0.693147
qmusic_behaviors_09_danceprv
5.000000
0.000000
3.000000
1.000000
0.00000
0.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
0.000000
1.000000
1.000000
0.00000
0.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
1.791759
0.000000
1.386294
0.693147
0.00000
0.000000
0.693147
0.693147
qmusic_behaviors_10_dancepub
0.000000
3.000000
1.000000
2.000000
0.00000
0.000000
0.000000
5.000000
qmusic_behaviors_10_dancepub_nonzero
0.000000
1.000000
1.000000
1.000000
0.00000
0.000000
0.000000
1.000000
qmusic_dancehours_nonzero
pid
015
064
044
084
101
053
098
058
qmusic_singinghours
5.000000
NaN
0.000000
0.000000
0.000000
5.000000
0.000000
0.000000
qmusic_dancehours
20.000000
5.000000
25.000000
10.000000
1.000000
20.000000
30.000000
0.500000
qmusic_instrumenthours
0.000000
0.000000
0.000000
5.000000
1.000000
1.000000
8.000000
0.000000
qmusic_gamehoursall
5.000000
0.000000
15.000000
0.000000
1.000000
0.000000
2.000000
0.000000
qmusic_gamehoursdrumsticks
0.000000
0.000000
1.000000
0.000000
1.000000
0.000000
0.000000
0.000000
qmusic_drumhours
0.000000
NaN
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
0.000000
qmusic_dancehours_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_instrumenthours_nonzero
0.000000
0.000000
0.000000
1.000000
1.000000
1.000000
1.000000
0.000000
qmusic_drumhours_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
0.000000
1.000000
0.000000
1.000000
0.000000
1.000000
0.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
0.000000
1.000000
0.000000
1.000000
0.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
14.000000
60.000000
24.000000
8.000000
14.000000
15.000000
40.000000
8.000000
qmusic_behaviors_07_yourself_ln1p
2.708050
4.110874
3.218876
2.197225
2.708050
2.772589
3.713572
2.197225
qmusic_behaviors_08_otherprs
10.000000
5.000000
5.000000
3.000000
1.000000
10.000000
2.000000
5.000000
qmusic_behaviors_08_otherprs_ln1p
2.397895
1.791759
1.791759
1.386294
0.693147
2.397895
1.098612
1.791759
qmusic_behaviors_09_danceprv
5.000000
2.000000
15.000000
1.000000
1.000000
10.000000
25.000000
0.500000
qmusic_behaviors_09_danceprv_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
1.791759
1.098612
2.772589
0.693147
0.693147
2.397895
3.258097
0.405465
qmusic_behaviors_10_dancepub
0.000000
5.000000
10.000000
1.000000
1.000000
3.000000
5.000000
0.000000
qmusic_behaviors_10_dancepub_nonzero
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
qmusic_instrumenthours_nonzero
pid
080
053
041
103
102
101
047
100
qmusic_singinghours
0.000000
5.000000
55.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours
5.000000
20.000000
2.000000
0.000000
0.000000
1.000000
0.000000
0.000000
qmusic_instrumenthours
3.000000
1.000000
8.000000
3.000000
0.500000
1.000000
4.000000
1.000000
qmusic_gamehoursall
2.000000
0.000000
0.000000
0.000000
0.500000
1.000000
3.000000
1.000000
qmusic_gamehoursdrumsticks
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
2.000000
1.000000
qmusic_drumhours
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
2.000000
0.000000
qmusic_singinghours_nonzero
0.000000
1.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours_nonzero
1.000000
1.000000
1.000000
0.000000
0.000000
1.000000
0.000000
0.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_drumhours_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
0.000000
0.000000
0.000000
1.000000
1.000000
1.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
1.000000
1.000000
qmusic_behaviors_07_yourself
20.000000
15.000000
15.000000
10.000000
28.000000
14.000000
5.500000
56.000000
qmusic_behaviors_07_yourself_ln1p
3.044522
2.772589
2.772589
2.397895
3.367296
2.708050
1.871802
4.043051
qmusic_behaviors_08_otherprs
10.000000
10.000000
4.500000
5.000000
7.000000
1.000000
1.500000
70.000000
qmusic_behaviors_08_otherprs_ln1p
2.397895
2.397895
1.704748
1.791759
2.079442
0.693147
0.916291
4.262680
qmusic_behaviors_09_danceprv
2.000000
10.000000
3.500000
0.000000
0.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
1.000000
1.000000
0.000000
0.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
1.098612
2.397895
1.504077
0.000000
0.000000
0.693147
0.693147
0.693147
qmusic_behaviors_10_dancepub
1.000000
3.000000
5.000000
0.000000
0.000000
1.000000
40.000000
20.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
1.000000
0.000000
0.000000
1.000000
1.000000
1.000000
qmusic_drumhours_nonzero
pid
060
075
034
113
047
119
076
074
qmusic_singinghours
0.000000
60.000000
0.000000
9.500000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours
30.000000
0.000000
0.000000
0.000000
0.000000
60.000000
0.000000
0.000000
qmusic_instrumenthours
2.000000
24.000000
7.000000
20.000000
4.000000
250.000000
0.000000
0.000000
qmusic_gamehoursall
1.000000
2.000000
0.000000
2.000000
3.000000
10.000000
0.000000
0.000000
qmusic_gamehoursdrumsticks
1.000000
0.000000
1.000000
1.000000
2.000000
10.000000
0.000000
0.000000
qmusic_drumhours
3.000000
30.000000
0.500000
5.500000
2.000000
200.000000
0.000000
0.000000
qmusic_singinghours_nonzero
0.000000
1.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
0.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
qmusic_drumhours_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
0.000000
1.000000
1.000000
1.000000
0.000000
0.000000
qmusic_gamehoursdrumsticks_nonzero
1.000000
0.000000
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
5.000000
12.500000
3.500000
6.000000
5.500000
72.000000
28.000000
1.500000
qmusic_behaviors_07_yourself_ln1p
1.791759
2.602690
1.504077
1.945910
1.871802
4.290459
3.367296
0.916291
qmusic_behaviors_08_otherprs
5.000000
6.000000
1.500000
2.000000
1.500000
80.000000
13.000000
0.500000
qmusic_behaviors_08_otherprs_ln1p
1.791759
1.945910
0.916291
1.098612
0.916291
4.394449
2.639057
0.405465
qmusic_behaviors_09_danceprv
1.000000
2.000000
1.000000
0.000000
1.000000
0.000000
0.000000
0.500000
qmusic_behaviors_09_danceprv_nonzero
1.000000
1.000000
1.000000
0.000000
1.000000
0.000000
0.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
0.693147
1.098612
0.693147
0.000000
0.693147
0.000000
0.000000
0.405465
qmusic_behaviors_10_dancepub
6.000000
1.000000
0.000000
0.000000
40.000000
10.000000
16.000000
0.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
0.000000
0.000000
1.000000
1.000000
1.000000
0.000000
qmusic_gamehoursall_nonzero
pid
015
096
059
060
061
062
066
075
qmusic_singinghours
5.000000
0.000000
0.000000
0.000000
2.000000
0.000000
30.000000
60.000000
qmusic_dancehours
20.000000
0.000000
0.000000
30.000000
5.000000
0.000000
16.000000
0.000000
qmusic_instrumenthours
0.000000
0.000000
1.000000
2.000000
1.000000
0.000000
60.000000
24.000000
qmusic_gamehoursall
5.000000
0.700000
4.500000
1.000000
2.500000
5.000000
20.000000
2.000000
qmusic_gamehoursdrumsticks
0.000000
0.250000
1.000000
1.000000
0.000000
0.000000
0.000000
0.000000
qmusic_drumhours
0.000000
0.000000
0.000000
3.000000
0.000000
0.000000
0.000000
30.000000
qmusic_singinghours_nonzero
1.000000
0.000000
0.000000
0.000000
1.000000
0.000000
1.000000
1.000000
qmusic_dancehours_nonzero
1.000000
0.000000
0.000000
1.000000
1.000000
0.000000
1.000000
0.000000
qmusic_instrumenthours_nonzero
0.000000
0.000000
1.000000
1.000000
1.000000
0.000000
1.000000
1.000000
qmusic_drumhours_nonzero
0.000000
0.000000
0.000000
1.000000
0.000000
0.000000
0.000000
1.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
1.000000
1.000000
1.000000
0.000000
0.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
14.000000
5.000000
5.000000
5.000000
1.000000
14.000000
42.000000
12.500000
qmusic_behaviors_07_yourself_ln1p
2.708050
1.791759
1.791759
1.791759
0.693147
2.708050
3.761200
2.602690
qmusic_behaviors_08_otherprs
10.000000
2.000000
21.000000
5.000000
1.000000
14.000000
20.000000
6.000000
qmusic_behaviors_08_otherprs_ln1p
2.397895
1.098612
3.091042
1.791759
0.693147
2.708050
3.044522
1.945910
qmusic_behaviors_09_danceprv
5.000000
2.000000
1.000000
1.000000
1.000000
3.000000
0.000000
2.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
1.791759
1.098612
0.693147
0.693147
0.693147
1.386294
0.000000
1.098612
qmusic_behaviors_10_dancepub
0.000000
4.000000
1.000000
6.000000
5.000000
20.000000
0.000000
1.000000
qmusic_behaviors_10_dancepub_nonzero
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
pid
069
113
086
060
059
096
051
100
qmusic_singinghours
0.000000
9.500000
0.000000
0.000000
0.000000
0.000000
2.000000
0.000000
qmusic_dancehours
0.000000
0.000000
16.000000
30.000000
0.000000
0.000000
1.000000
0.000000
qmusic_instrumenthours
0.000000
20.000000
8.000000
2.000000
1.000000
0.000000
0.000000
1.000000
qmusic_gamehoursall
5.000000
2.000000
18.000000
1.000000
4.500000
0.700000
1.000000
1.000000
qmusic_gamehoursdrumsticks
0.500000
1.000000
5.000000
1.000000
1.000000
0.250000
0.250000
1.000000
qmusic_drumhours
0.000000
5.500000
0.000000
3.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
qmusic_dancehours_nonzero
0.000000
0.000000
1.000000
1.000000
0.000000
0.000000
1.000000
0.000000
qmusic_instrumenthours_nonzero
0.000000
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
1.000000
qmusic_drumhours_nonzero
0.000000
1.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_07_yourself
20.000000
6.000000
12.000000
5.000000
5.000000
5.000000
2.000000
56.000000
qmusic_behaviors_07_yourself_ln1p
3.044522
1.945910
2.564949
1.791759
1.791759
1.791759
1.098612
4.043051
qmusic_behaviors_08_otherprs
5.000000
2.000000
0.000000
5.000000
21.000000
2.000000
1.000000
70.000000
qmusic_behaviors_08_otherprs_ln1p
1.791759
1.098612
0.000000
1.791759
3.091042
1.098612
0.693147
4.262680
qmusic_behaviors_09_danceprv
1.000000
0.000000
4.000000
1.000000
1.000000
2.000000
0.000000
1.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
0.000000
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
0.693147
0.000000
1.609438
0.693147
0.693147
1.098612
0.000000
0.693147
qmusic_behaviors_10_dancepub
0.000000
0.000000
2.000000
6.000000
1.000000
4.000000
0.000000
20.000000
qmusic_behaviors_10_dancepub_nonzero
0.000000
0.000000
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
qmusic_behaviors_07_yourself
pid
056
091
119
064
100
024
032
026
qmusic_singinghours
20.000000
0.000000
0.000000
NaN
0.000000
0.000000
10.000000
0.000000
qmusic_dancehours
0.000000
0.000000
60.000000
5.000000
0.000000
5.000000
2.000000
0.000000
qmusic_instrumenthours
20.000000
3.000000
250.000000
0.000000
1.000000
0.000000
40.000000
0.000000
qmusic_gamehoursall
20.000000
0.000000
10.000000
0.000000
1.000000
10.000000
0.000000
0.000000
qmusic_gamehoursdrumsticks
0.000000
0.000000
10.000000
0.000000
1.000000
5.000000
0.000000
0.000000
qmusic_drumhours
0.000000
0.000000
200.000000
NaN
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
qmusic_dancehours_nonzero
0.000000
0.000000
1.000000
1.000000
0.000000
1.000000
1.000000
0.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
0.000000
1.000000
0.000000
1.000000
0.000000
qmusic_drumhours_nonzero
0.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
0.000000
1.000000
0.000000
1.000000
1.000000
0.000000
0.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
0.000000
1.000000
0.000000
1.000000
1.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
100.000000
80.000000
72.000000
60.000000
56.000000
50.000000
50.000000
50.000000
qmusic_behaviors_07_yourself_ln1p
4.615121
4.394449
4.290459
4.110874
4.043051
3.931826
3.931826
3.931826
qmusic_behaviors_08_otherprs
72.000000
20.000000
80.000000
5.000000
70.000000
10.000000
0.000000
30.000000
qmusic_behaviors_08_otherprs_ln1p
4.290459
3.044522
4.394449
1.791759
4.262680
2.397895
0.000000
3.433987
qmusic_behaviors_09_danceprv
24.000000
0.000000
0.000000
2.000000
1.000000
15.000000
20.000000
2.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
0.000000
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
3.218876
0.000000
0.000000
1.098612
0.693147
2.772589
3.044522
1.098612
qmusic_behaviors_10_dancepub
10.000000
1.000000
10.000000
5.000000
20.000000
5.000000
0.000000
0.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
qmusic_behaviors_07_yourself_ln1p
pid
056
091
119
064
100
024
032
026
qmusic_singinghours
20.000000
0.000000
0.000000
NaN
0.000000
0.000000
10.000000
0.000000
qmusic_dancehours
0.000000
0.000000
60.000000
5.000000
0.000000
5.000000
2.000000
0.000000
qmusic_instrumenthours
20.000000
3.000000
250.000000
0.000000
1.000000
0.000000
40.000000
0.000000
qmusic_gamehoursall
20.000000
0.000000
10.000000
0.000000
1.000000
10.000000
0.000000
0.000000
qmusic_gamehoursdrumsticks
0.000000
0.000000
10.000000
0.000000
1.000000
5.000000
0.000000
0.000000
qmusic_drumhours
0.000000
0.000000
200.000000
NaN
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
qmusic_dancehours_nonzero
0.000000
0.000000
1.000000
1.000000
0.000000
1.000000
1.000000
0.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
0.000000
1.000000
0.000000
1.000000
0.000000
qmusic_drumhours_nonzero
0.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
0.000000
1.000000
0.000000
1.000000
1.000000
0.000000
0.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
0.000000
1.000000
0.000000
1.000000
1.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
100.000000
80.000000
72.000000
60.000000
56.000000
50.000000
50.000000
50.000000
qmusic_behaviors_07_yourself_ln1p
4.615121
4.394449
4.290459
4.110874
4.043051
3.931826
3.931826
3.931826
qmusic_behaviors_08_otherprs
72.000000
20.000000
80.000000
5.000000
70.000000
10.000000
0.000000
30.000000
qmusic_behaviors_08_otherprs_ln1p
4.290459
3.044522
4.394449
1.791759
4.262680
2.397895
0.000000
3.433987
qmusic_behaviors_09_danceprv
24.000000
0.000000
0.000000
2.000000
1.000000
15.000000
20.000000
2.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
0.000000
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
3.218876
0.000000
0.000000
1.098612
0.693147
2.772589
3.044522
1.098612
qmusic_behaviors_10_dancepub
10.000000
1.000000
10.000000
5.000000
20.000000
5.000000
0.000000
0.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
qmusic_behaviors_08_otherprs
pid
119
056
100
055
026
117
020
022
qmusic_singinghours
0.000000
20.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours
60.000000
0.000000
0.000000
0.000000
0.000000
20.000000
0.000000
0.000000
qmusic_instrumenthours
250.000000
20.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall
10.000000
20.000000
1.000000
10.000000
0.000000
8.000000
5.000000
0.000000
qmusic_gamehoursdrumsticks
10.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_drumhours
200.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
0.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_drumhours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
1.000000
0.000000
qmusic_gamehoursdrumsticks_nonzero
1.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
72.000000
100.000000
56.000000
24.000000
50.000000
5.000000
50.000000
50.000000
qmusic_behaviors_07_yourself_ln1p
4.290459
4.615121
4.043051
3.218876
3.931826
1.791759
3.931826
3.931826
qmusic_behaviors_08_otherprs
80.000000
72.000000
70.000000
60.000000
30.000000
30.000000
30.000000
30.000000
qmusic_behaviors_08_otherprs_ln1p
4.394449
4.290459
4.262680
4.110874
3.433987
3.433987
3.433987
3.433987
qmusic_behaviors_09_danceprv
0.000000
24.000000
1.000000
10.000000
2.000000
2.000000
10.000000
50.000000
qmusic_behaviors_09_danceprv_nonzero
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
0.000000
3.218876
0.693147
2.397895
1.098612
1.098612
2.397895
3.931826
qmusic_behaviors_10_dancepub
10.000000
10.000000
20.000000
0.000000
0.000000
15.000000
0.000000
0.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
1.000000
0.000000
0.000000
1.000000
0.000000
0.000000
qmusic_behaviors_08_otherprs_ln1p
pid
119
056
100
055
026
117
020
022
qmusic_singinghours
0.000000
20.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours
60.000000
0.000000
0.000000
0.000000
0.000000
20.000000
0.000000
0.000000
qmusic_instrumenthours
250.000000
20.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall
10.000000
20.000000
1.000000
10.000000
0.000000
8.000000
5.000000
0.000000
qmusic_gamehoursdrumsticks
10.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_drumhours
200.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
0.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_drumhours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
1.000000
0.000000
qmusic_gamehoursdrumsticks_nonzero
1.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
72.000000
100.000000
56.000000
24.000000
50.000000
5.000000
50.000000
50.000000
qmusic_behaviors_07_yourself_ln1p
4.290459
4.615121
4.043051
3.218876
3.931826
1.791759
3.931826
3.931826
qmusic_behaviors_08_otherprs
80.000000
72.000000
70.000000
60.000000
30.000000
30.000000
30.000000
30.000000
qmusic_behaviors_08_otherprs_ln1p
4.394449
4.290459
4.262680
4.110874
3.433987
3.433987
3.433987
3.433987
qmusic_behaviors_09_danceprv
0.000000
24.000000
1.000000
10.000000
2.000000
2.000000
10.000000
50.000000
qmusic_behaviors_09_danceprv_nonzero
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
0.000000
3.218876
0.693147
2.397895
1.098612
1.098612
2.397895
3.931826
qmusic_behaviors_10_dancepub
10.000000
10.000000
20.000000
0.000000
0.000000
15.000000
0.000000
0.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
1.000000
0.000000
0.000000
1.000000
0.000000
0.000000
qmusic_behaviors_09_danceprv
pid
022
019
036
098
056
032
044
024
qmusic_singinghours
0.000000
0.000000
0.000000
0.000000
20.000000
10.000000
0.000000
0.000000
qmusic_dancehours
0.000000
50.000000
0.000000
30.000000
0.000000
2.000000
25.000000
5.000000
qmusic_instrumenthours
0.000000
5.000000
0.000000
8.000000
20.000000
40.000000
0.000000
0.000000
qmusic_gamehoursall
0.000000
10.000000
240.000000
2.000000
20.000000
0.000000
15.000000
10.000000
qmusic_gamehoursdrumsticks
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
5.000000
qmusic_drumhours
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
0.000000
0.000000
0.000000
0.000000
1.000000
1.000000
0.000000
0.000000
qmusic_dancehours_nonzero
0.000000
1.000000
0.000000
1.000000
0.000000
1.000000
1.000000
1.000000
qmusic_instrumenthours_nonzero
0.000000
1.000000
0.000000
1.000000
1.000000
1.000000
0.000000
0.000000
qmusic_drumhours_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
0.000000
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
1.000000
qmusic_behaviors_07_yourself
50.000000
10.000000
40.000000
40.000000
100.000000
50.000000
24.000000
50.000000
qmusic_behaviors_07_yourself_ln1p
3.931826
2.397895
3.713572
3.713572
4.615121
3.931826
3.218876
3.931826
qmusic_behaviors_08_otherprs
30.000000
5.000000
10.000000
2.000000
72.000000
0.000000
5.000000
10.000000
qmusic_behaviors_08_otherprs_ln1p
3.433987
1.791759
2.397895
1.098612
4.290459
0.000000
1.791759
2.397895
qmusic_behaviors_09_danceprv
50.000000
30.000000
30.000000
25.000000
24.000000
20.000000
15.000000
15.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
3.931826
3.433987
3.433987
3.258097
3.218876
3.044522
2.772589
2.772589
qmusic_behaviors_10_dancepub
0.000000
24.000000
0.000000
5.000000
10.000000
0.000000
10.000000
5.000000
qmusic_behaviors_10_dancepub_nonzero
0.000000
1.000000
0.000000
1.000000
1.000000
0.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_nonzero
pid
015
060
087
086
084
082
080
078
qmusic_singinghours
5.000000
0.000000
2.000000
0.000000
0.000000
13.000000
0.000000
27.000000
qmusic_dancehours
20.000000
30.000000
0.000000
16.000000
10.000000
1.000000
5.000000
6.000000
qmusic_instrumenthours
0.000000
2.000000
0.000000
8.000000
5.000000
0.000000
3.000000
28.000000
qmusic_gamehoursall
5.000000
1.000000
1.000000
18.000000
0.000000
1.000000
2.000000
3.000000
qmusic_gamehoursdrumsticks
0.000000
1.000000
0.000000
5.000000
0.000000
0.000000
0.000000
0.000000
qmusic_drumhours
0.000000
3.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
1.000000
0.000000
1.000000
0.000000
0.000000
1.000000
0.000000
1.000000
qmusic_dancehours_nonzero
1.000000
1.000000
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_instrumenthours_nonzero
0.000000
1.000000
0.000000
1.000000
1.000000
0.000000
1.000000
1.000000
qmusic_drumhours_nonzero
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
1.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
1.000000
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
14.000000
5.000000
17.000000
12.000000
8.000000
40.000000
20.000000
8.000000
qmusic_behaviors_07_yourself_ln1p
2.708050
1.791759
2.890372
2.564949
2.197225
3.713572
3.044522
2.197225
qmusic_behaviors_08_otherprs
10.000000
5.000000
5.000000
0.000000
3.000000
2.000000
10.000000
3.000000
qmusic_behaviors_08_otherprs_ln1p
2.397895
1.791759
1.791759
0.000000
1.386294
1.098612
2.397895
1.386294
qmusic_behaviors_09_danceprv
5.000000
1.000000
1.000000
4.000000
1.000000
1.000000
2.000000
3.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
1.791759
0.693147
0.693147
1.609438
0.693147
0.693147
1.098612
1.386294
qmusic_behaviors_10_dancepub
0.000000
6.000000
0.000000
2.000000
1.000000
2.000000
1.000000
1.000000
qmusic_behaviors_10_dancepub_nonzero
0.000000
1.000000
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
pid
022
019
036
098
056
032
044
024
qmusic_singinghours
0.000000
0.000000
0.000000
0.000000
20.000000
10.000000
0.000000
0.000000
qmusic_dancehours
0.000000
50.000000
0.000000
30.000000
0.000000
2.000000
25.000000
5.000000
qmusic_instrumenthours
0.000000
5.000000
0.000000
8.000000
20.000000
40.000000
0.000000
0.000000
qmusic_gamehoursall
0.000000
10.000000
240.000000
2.000000
20.000000
0.000000
15.000000
10.000000
qmusic_gamehoursdrumsticks
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
5.000000
qmusic_drumhours
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
0.000000
0.000000
0.000000
0.000000
1.000000
1.000000
0.000000
0.000000
qmusic_dancehours_nonzero
0.000000
1.000000
0.000000
1.000000
0.000000
1.000000
1.000000
1.000000
qmusic_instrumenthours_nonzero
0.000000
1.000000
0.000000
1.000000
1.000000
1.000000
0.000000
0.000000
qmusic_drumhours_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
0.000000
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
1.000000
qmusic_behaviors_07_yourself
50.000000
10.000000
40.000000
40.000000
100.000000
50.000000
24.000000
50.000000
qmusic_behaviors_07_yourself_ln1p
3.931826
2.397895
3.713572
3.713572
4.615121
3.931826
3.218876
3.931826
qmusic_behaviors_08_otherprs
30.000000
5.000000
10.000000
2.000000
72.000000
0.000000
5.000000
10.000000
qmusic_behaviors_08_otherprs_ln1p
3.433987
1.791759
2.397895
1.098612
4.290459
0.000000
1.791759
2.397895
qmusic_behaviors_09_danceprv
50.000000
30.000000
30.000000
25.000000
24.000000
20.000000
15.000000
15.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
3.931826
3.433987
3.433987
3.258097
3.218876
3.044522
2.772589
2.772589
qmusic_behaviors_10_dancepub
0.000000
24.000000
0.000000
5.000000
10.000000
0.000000
10.000000
5.000000
qmusic_behaviors_10_dancepub_nonzero
0.000000
1.000000
0.000000
1.000000
1.000000
0.000000
1.000000
1.000000
qmusic_behaviors_10_dancepub
pid
047
019
100
062
076
092
117
049
qmusic_singinghours
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours
0.000000
50.000000
0.000000
0.000000
0.000000
0.000000
20.000000
0.000000
qmusic_instrumenthours
4.000000
5.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall
3.000000
10.000000
1.000000
5.000000
0.000000
0.000000
8.000000
0.000000
qmusic_gamehoursdrumsticks
2.000000
1.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_drumhours
2.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_singinghours_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_dancehours_nonzero
0.000000
1.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
qmusic_instrumenthours_nonzero
1.000000
1.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_drumhours_nonzero
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
1.000000
1.000000
1.000000
0.000000
0.000000
1.000000
0.000000
qmusic_gamehoursdrumsticks_nonzero
1.000000
1.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
qmusic_behaviors_07_yourself
5.500000
10.000000
56.000000
14.000000
28.000000
7.000000
5.000000
20.000000
qmusic_behaviors_07_yourself_ln1p
1.871802
2.397895
4.043051
2.708050
3.367296
2.079442
1.791759
3.044522
qmusic_behaviors_08_otherprs
1.500000
5.000000
70.000000
14.000000
13.000000
3.000000
30.000000
5.000000
qmusic_behaviors_08_otherprs_ln1p
0.916291
1.791759
4.262680
2.708050
2.639057
1.386294
3.433987
1.791759
qmusic_behaviors_09_danceprv
1.000000
30.000000
1.000000
3.000000
0.000000
2.000000
2.000000
0.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
1.000000
1.000000
1.000000
0.000000
1.000000
1.000000
0.000000
qmusic_behaviors_09_danceprv_ln1p
0.693147
3.433987
0.693147
1.386294
0.000000
1.098612
1.098612
0.000000
qmusic_behaviors_10_dancepub
40.000000
24.000000
20.000000
20.000000
16.000000
15.000000
15.000000
13.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_10_dancepub_nonzero
pid
121
049
101
056
100
059
060
061
qmusic_singinghours
0.000000
0.000000
0.000000
20.000000
0.000000
0.000000
0.000000
2.000000
qmusic_dancehours
0.000000
0.000000
1.000000
0.000000
0.000000
0.000000
30.000000
5.000000
qmusic_instrumenthours
0.000000
0.000000
1.000000
20.000000
1.000000
1.000000
2.000000
1.000000
qmusic_gamehoursall
2.000000
0.000000
1.000000
20.000000
1.000000
4.500000
1.000000
2.500000
qmusic_gamehoursdrumsticks
0.000000
0.000000
1.000000
0.000000
1.000000
1.000000
1.000000
0.000000
qmusic_drumhours
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
3.000000
0.000000
qmusic_singinghours_nonzero
0.000000
0.000000
0.000000
1.000000
0.000000
0.000000
0.000000
1.000000
qmusic_dancehours_nonzero
0.000000
0.000000
1.000000
0.000000
0.000000
0.000000
1.000000
1.000000
qmusic_instrumenthours_nonzero
0.000000
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_drumhours_nonzero
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
qmusic_gamehoursall_nonzero
1.000000
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_gamehoursdrumsticks_nonzero
0.000000
0.000000
1.000000
0.000000
1.000000
1.000000
1.000000
0.000000
qmusic_behaviors_07_yourself
15.000000
20.000000
14.000000
100.000000
56.000000
5.000000
5.000000
1.000000
qmusic_behaviors_07_yourself_ln1p
2.772589
3.044522
2.708050
4.615121
4.043051
1.791759
1.791759
0.693147
qmusic_behaviors_08_otherprs
5.000000
5.000000
1.000000
72.000000
70.000000
21.000000
5.000000
1.000000
qmusic_behaviors_08_otherprs_ln1p
1.791759
1.791759
0.693147
4.290459
4.262680
3.091042
1.791759
0.693147
qmusic_behaviors_09_danceprv
1.000000
0.000000
1.000000
24.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_nonzero
1.000000
0.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
qmusic_behaviors_09_danceprv_ln1p
0.693147
0.000000
0.693147
3.218876
0.693147
0.693147
0.693147
0.693147
qmusic_behaviors_10_dancepub
2.000000
13.000000
1.000000
10.000000
20.000000
1.000000
6.000000
5.000000
qmusic_behaviors_10_dancepub_nonzero
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
In [51]:
quickcompare('^calc')
raw
log1p
sqrt
In [52]:
concat_matches(dfo, 'sumhours', 'qmusic_dance', 'iq').T
Out[52]:
pid
015
016
017
018
019
020
021
022
024
025
...
112
113
114
115
116
117
118
119
120
121
notes_qmusic_dance
(Was a kids dancing program at my elementary s...
...
20 hours = zumba dance fitness + belly dance
qmusic_danceyn
1
1
1
1
1
0
0
0
1
1
...
1
0
1
1
1
1
1
1
0
0
qmusic_dancestyle
ballet
show choir
NDI
ballroom, country (2-step)
jazz
ballroom
ballroom dance
...
variety of dance
(blank)
ballet
ballroom
hip hop
belly dance
hip hop
pop, ballet
qmusic_dancelevel
2
2
1
3
4
0
0
0
1
3
...
5
0
3
2
3
4
3
3
0
0
qmusic_dancehours
20
1
0
10
50
0
0
0
5
8
...
2
0
10
5
3
20
24
60
0
0
qmusic_dancehours_nonzero
1
1
0
1
1
0
0
0
1
1
...
1
0
1
1
1
1
1
1
0
0
qmusic_dancelevel_ln1p
1.098612
1.098612
0.6931472
1.386294
1.609438
0
0
0
0.6931472
1.386294
...
1.791759
0
1.386294
1.098612
1.386294
1.609438
1.386294
1.386294
0
0
qmusic_dancelevel_tophalf
1
1
0
1
1
0
0
0
0
1
...
1
0
1
1
1
1
1
1
0
0
calc_fsiq2
89
127
108
102
109
105
95
102
99
95
...
87
94
122
123
120
95
108
105
100
97
9 rows × 99 columns
In [54]:
#Finally: set NaNs back to '77777'
dfo.replace(np.nan, '77777', inplace=True)
scales_output_updated = '2014-10-29a'
prefix = "c:/db_pickles/pickle - dfo-scales - "
import cPickle as pickle
output_file= prefix + scales_output_updated + '.pickle'
pickle.dump(dfo, open(output_file, "wb"))
# Proceed with pickle to Part 5
Content source: coej/Timing-study-data-processing
Similar notebooks: