<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="31"/>
        <last_saved_by value="Andy_Brice_using_Easy_Data_Transform_v1_19_1_on_Windows_10_Version_2004_at_2021_07_14_10_09_16"/>
        <locale value="en_US"/>
        <id value="7602050d327507060b7076010c0138"/>
        <snap_to_grid value="1"/>
        <notes value="Based%20on%20examples%20in%20%27Tidy%20Data%27%20by%20Hadley%20Wickham%3A%0Ahttps%3A%2F%2Fvita.had.co.nz%2Fpapers%2Ftidy-data.pdf"/>
        <doc_path value="C%3A%5CUsers%5Candy%5CDropbox%5Ctidy%5Ctidy_data.transform"/>
    </meta>
    <inputs>
        <input pos="-90^-45" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-90-45" watching="0" medium="1" auto_fixed_widths="1" header="1" trim="1" file_type="0" id="26" custom_delimiter="%2A" text="religion%2C%3C%2410k%2C%2410-20k%2C%2420-30k%2C%2430-40k%2C%2440-50k%2C%2450-75k%0AAgnostic%2C27%2C34%2C60%2C81%2C76%2C137%0AAtheist%2C12%2C27%2C37%2C52%2C35%2C70%0ABuddhist%2C27%2C21%2C30%2C34%2C33%2C58" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
        <input pos="-90^194.4" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-90194.4" watching="0" medium="1" auto_fixed_widths="1" header="1" trim="1" file_type="0" id="30" custom_delimiter="%2A" text="year%2Cartist%2Ctrack%2Ctime%2Cdate.entered%2Cwk1%2Cwk2%2Cwk3%0A2000%2C2%20Pac%2CBaby%20Don%E2%80%99t%20Cry%2C4%3A22%2C2000-02-26%2C87%2C82%2C72%0A2000%2C2Ge%2Bher%2CThe%20Hardest%20Part%20Of%20...%2C3%3A15%2C2000-09-02%2C91%2C87%2C92%0A2000%2C3%20Doors%20Down%2CKryptonite%2C3%3A53%2C2000-04-08%2C81%2C70%2C68" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
        <input pos="-90^433.8" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-90433.8" watching="0" medium="1" auto_fixed_widths="1" header="1" trim="1" file_type="0" id="34" custom_delimiter="%2A" text="country%2Cyear%2Cm014%2Cm1534%2Cm3564%2Cm65%2Cf014%2Cf1534%2Cf3564%2Cf65%0AAD%2C2000%2C0%2C0%2C1%2C0%2C0%2C0%2C0%2C0%0AAE%2C2000%2C2%2C4%2C4%2C6%2C5%2C12%2C10%2C6%0AAF%2C2000%2C52%2C228%2C183%2C149%2C129%2C94%2C80%2C149" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
        <input pos="-90^792.9" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-90792.9" watching="0" medium="1" auto_fixed_widths="1" header="1" trim="1" file_type="0" id="48" custom_delimiter="%2A" text="id%2Cyear%2Cmonth%2Celement%2Cd1%2Cd2%2Cd3%2Cd4%2Cd5%2Cd6%2Cd7%2Cd8%0AMX17004%2C2010%2C1%2Ctmax%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%0AMX17004%2C2010%2C1%2Ctmin%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%0AMX17004%2C2010%2C2%2Ctmax%2C%E2%80%94%2C27.3%2C24.1%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%0AMX17004%2C2010%2C2%2Ctmin%2C%E2%80%94%2C14.4%2C14.4%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%0AMX17004%2C2010%2C3%2Ctmax%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C32.1%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%0AMX17004%2C2010%2C3%2Ctmin%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%2C14.2%2C%E2%80%94%2C%E2%80%94%2C%E2%80%94%0A" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="29" name="Gather" pos="149.4^-45" pos_v12="149.4-45">
            <parameters>
                <parameter type="1" name="Columns" value="234567"/>
                <parameter type="7" name="Key_Column" value="income"/>
                <parameter type="7" name="Value_Column" value="frequency"/>
            </parameters>
        </transform>
        <transform id="32" name="Gather" pos="149.4^194.4" pos_v12="149.4194.4">
            <parameters>
                <parameter type="1" name="Columns" value="678"/>
                <parameter type="7" name="Key_Column" value="week"/>
                <parameter type="7" name="Value_Column" value="rank"/>
            </parameters>
        </transform>
        <transform id="33" name="Replace_Multi" pos="388.8^194.4" pos_v12="388.8194.4">
            <parameters>
                <parameter type="1" name="Columns" value="6"/>
                <parameter type="16" name="Replace" value="0wk"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="36" name="Gather" pos="149.4^433.8" pos_v12="149.4433.8">
            <parameters>
                <parameter type="1" name="Columns" value="345678910"/>
                <parameter type="7" name="Key_Column" value="column"/>
                <parameter type="7" name="Value_Column" value="cases"/>
            </parameters>
        </transform>
        <transform id="40" name="If" pos="388.8^433.8" pos_v12="388.8433.8">
            <parameters>
                <parameter type="7" name="New_Name" value="gender"/>
                <parameter type="10" name="If" value="*StartIf*32m*EndIf*mf"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="41" name="Chop" pos="628.2^433.8" pos_v12="628.2433.8">
            <parameters>
                <parameter type="1" name="Columns" value="3"/>
                <parameter type="8" name="Length" value="1"/>
                <parameter type="6" name="From" value="Start"/>
            </parameters>
        </transform>
        <transform id="42" name="Rename_Cols" pos="149.4^553.5" pos_v12="149.4553.5">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2A%2ANORENAME%2Aage%2ANORENAME%2A%2ANORENAME%2A"/>
            </parameters>
        </transform>
        <transform id="43" name="Replace_Multi" pos="388.8^553.5" pos_v12="388.8553.5">
            <parameters>
                <parameter type="1" name="Columns" value="3"/>
                <parameter type="16" name="Replace" value="00140-140153415-340356435-6406565%2B"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="44" name="Reorder" pos="628.2^553.5" pos_v12="628.2553.5">
            <parameters>
                <parameter type="4" name="Columns" value="12354"/>
            </parameters>
        </transform>
        <transform id="50" name="Gather" pos="149.4^792.9" pos_v12="149.4792.9">
            <parameters>
                <parameter type="1" name="Columns" value="56789101112"/>
                <parameter type="7" name="Key_Column" value="day"/>
                <parameter type="7" name="Value_Column" value="value"/>
            </parameters>
        </transform>
        <transform id="51" name="Filter" pos="388.8^792.9" pos_v12="388.8792.9">
            <parameters>
                <parameter type="3" name="Columns" value="0161%E2%80%94"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
        <transform id="52" name="Chop" pos="628.2^792.9" pos_v12="628.2792.9">
            <parameters>
                <parameter type="1" name="Columns" value="5"/>
                <parameter type="8" name="Length" value="1"/>
                <parameter type="6" name="From" value="Start"/>
            </parameters>
        </transform>
        <transform id="53" name="Pad" pos="867.6^792.9" pos_v12="867.6792.9">
            <parameters>
                <parameter type="1" name="Columns" value="35"/>
                <parameter type="8" name="Length" value="2"/>
                <parameter type="6" name="Left_Right" value="Left"/>
                <parameter type="9" name="Pad_With" value="0"/>
            </parameters>
        </transform>
        <transform id="54" name="Concat" pos="149.4^912.6" pos_v12="149.4912.6">
            <parameters>
                <parameter type="1" name="Columns" value="235"/>
                <parameter type="7" name="Delimiter" value="-"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
            </parameters>
        </transform>
        <transform id="55" name="Remove" pos="388.8^912.6" pos_v12="388.8912.6">
            <parameters>
                <parameter type="11" name="Columns" value="1467"/>
            </parameters>
        </transform>
        <transform id="56" name="Rename_Cols" pos="628.2^912.6" pos_v12="628.2912.6">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2Adate"/>
            </parameters>
        </transform>
        <transform id="57" name="Spread" pos="867.6^912.6" pos_v12="867.6912.6">
            <parameters>
                <parameter type="0" name="Key_Column" value="2"/>
                <parameter type="0" name="Value_Column" value="3"/>
                <parameter type="7" name="Missing_Value" value=""/>
                <parameter type="8" name="Min_New_Cols" value="0"/>
                <parameter type="8" name="Max_New_Cols" value="100"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes>
        <note id="45" comment="Example%201" pos_v12="-329.4-45" color="255%1F255%1F255" arrow="2"/>
        <note id="46" comment="Example%202" pos_v12="-329.4194.4" color="255%1F255%1F255" arrow="2"/>
        <note id="47" comment="Example%203" pos_v12="-329.4433.8" color="255%1F255%1F255" arrow="2"/>
        <note id="49" comment="Example%204" pos_v12="-329.4792.9" color="255%1F255%1F255" arrow="2"/>
    </notes>
    <connections>
        <connection start_id="26" end_id="29"/>
        <connection start_id="30" end_id="32"/>
        <connection start_id="32" end_id="33"/>
        <connection start_id="34" end_id="36"/>
        <connection start_id="36" end_id="40"/>
        <connection start_id="40" end_id="41"/>
        <connection start_id="41" end_id="42"/>
        <connection start_id="42" end_id="43"/>
        <connection start_id="43" end_id="44"/>
        <connection start_id="48" end_id="50"/>
        <connection start_id="50" end_id="51"/>
        <connection start_id="51" end_id="52"/>
        <connection start_id="52" end_id="53"/>
        <connection start_id="53" end_id="54"/>
        <connection start_id="54" end_id="55"/>
        <connection start_id="55" end_id="56"/>
        <connection start_id="56" end_id="57"/>
    </connections>
    <batch_values/>
</root>
