Transactions.csv 2017年2月28日までのユーザーのトランザクション。
msno：ユーザーID paymentmethodid：支払い方法 paymentplandays：メンバーシッププランの日数 planlistprice：新台湾ドル（NTD） actualamountpaid：新台湾ドル（NTD） isautorenew transactiondate：format %Y%m%d Membershipexpiredate：形式 %Y%m%d iscancel：ユーザーがこのトランザクションのメンバーシップをキャンセルしたかどうか。
Update project metadata
Update project metadata
Transform Step: Add 'rename(paymentdate = …' (kkboxtranqWp6rIT2) to Data Frame 'kkboxtran'
Transform Step: Update 'select(msno, actualam…' (kkboxtranJTs3WGB2) of Data Frame kkboxtran
Transform Step: Update 'select(msno, paymentm…' (kkboxtranJTs3WGB2) of Data Frame kkboxtran
Transform Step: Update 'arrange(id, transactio…' (kkboxtranwxi8kfU0) of Data Frame kkbox_tran
Transform Step: Update 'reordercols(id, trans…' (kkboxtrannhm2VaF8) of Data Frame kkboxtran
Transform Step: Update 'arrange(transactionda…' (kkboxtranwxi8kfU0) of Data Frame kkboxtran
Transform Step: Update 'arrange(transactiondate)' (kkboxtranwxi8kfU0) of Data Frame kkboxtran
Transform Step: Move 'arrange(msno, transact…' (kkboxtranwxi8kfU0) within 'kkbox_tran'
Transform Step: Update 'reordercols(transacti…' (kkboxtrannhm2VaF8) of Data Frame kkboxtran
Transform Step: Move 'reordercols(msno, tra…' (kkboxtrannhm2VaF8) within 'kkboxtran'
Transform Step: Add 'select(-msno)' (kkboxtrankRh9OWv1) to Data Frame 'kkbox_tran'
Transform Step: Add 'leftjoin(ptran, by =…' (kkboxtranbHm2gOq3) to Data Frame 'kkbox_tran'
Modified ptranSource1.json
Modified p_tran.csv
Modified p_tran.metadata.json
Modified ptran.sampledata.json
Transform Step: Add Source (ptranSource1) to Data Frame 'p_tran'
Viz: Update Chart 1 (pLk5nlg2)
Analytics: Update bSn8zZk2
Analytics: Update bSn8zZk2
Analytics: Add Analytics 1(bSn8zZk2)
Viz: Update Chart 1 (pLk5nlg2)
Viz: Update Chart 1 (pLk5nlg2)
Viz: Add 'Chart 1' (pLk5nlg2)
Transform Step: Update 'arrange(msno, transact…' (kkboxtranwxi8kfU0) of Data Frame kkbox_tran
Transform Step: Add 'arrange(msno)' (kkboxtranwxi8kfU0) to Data Frame 'kkbox_tran'
Transform Step: Add 'reordercols(msno, tra…' (kkboxtrannhm2VaF8) to Data Frame 'kkboxtran'
Transform Step: Add 'select(msno, actualam…' (kkboxtranJTs3WGB2) to Data Frame 'kkboxtran'
Modified kkboxtranSource1.json
Modified kkbox_tran.csv
Modified kkbox_tran.metadata.json
Modified kkboxtran.sampledata.json
Transform Step: Add Source (kkboxtranSource1) to Data Frame 'kkbox_tran'
Create project