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"
# 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)
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()
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 |
#show missing values from original CSV entry ('77777')
html_print(dfo.loc['053'].head(10)) #example P with missing WASI subtest
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 |
# 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])
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... |
# View missing values
htmljoin([pd.DataFrame(row[row.isnull()])[:7].T
for i, row in dfo.iterrows()
if len(row[row.isnull()]) > 0])
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 |
simple_hour_items = col_matches(dfo, 'hours$') # '$' --> matches only end of name
simple_hour_items
['qmusic_singinghours', 'qmusic_dancehours', 'qmusic_instrumenthours', 'qmusic_drumhours']
# 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
#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
pos_skewed_vars = ['qmusic_behaviors_07_yourself',
'qmusic_behaviors_08_otherprs',
'qmusic_behaviors_09_danceprv',
'qmusic_dancelevel']
compare_transformations(dfo, pos_skewed_vars,
{'log1p': np.log1p,
'sqrt': np.sqrt,},
figsize=(15,7))
raw
log1p
sqrt
for varname in pos_skewed_vars:
s = dfo[varname]
dfo[varname + '_ln1p'] = np.log1p(s) #ln of (x + 1)
from functools import partial
medsplit = partial(pd.qcut, q=2, labels=False)
compare_transformations(dfo,
['qmusic_dancelevel'],
{'medsplit': medsplit},
figsize=(10,3))
raw
medsplit
dfo['qmusic_dancelevel_tophalf'] = medsplit(dfo['qmusic_dancelevel'])
# same as recoding as (0-1) --> 0
# (2-7) --> 1
compare_transformations(dfo,
col_matches(dfo, 'rel_totalmonths'),
{'log1p': np.log1p,
'sqrt': np.sqrt, },
figsize=(10,3))
raw
log1p
sqrt
quickcompare('times$', size=(5,3))
raw
log1p
sqrt
#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())
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 |
#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)
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 |
quickcompare('^calc')
raw
log1p
sqrt
concat_matches(dfo, 'sumhours', 'qmusic_dance', 'iq').T
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
#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