Greetings,

could someone please, help to perform this exercise in R programming?

1-Using the dplyr package, use the 6 different operations to analyze/transform the data - GroupBy, Summarize, Mutate, Filter, Select, and Arrange

2- Using the purrr package - perform 2 functions on your dataset. You could use zip_n, keep, discard, compact, etc.

3- Use the cbind and rbind functions on your dataset

4- Split a string, then concatenate the results back together

Thank you

This is the Housing dataset

SaleDate	SalePrice	sale_reason	sale_instrument	sale_warning	sitetype	addr_full	zip5	ctyname	postalctyn	lon	lat	building_grade	square_feet_total_living	bedrooms	bath_full_count	bath_half_count	bath_3qtr_count	year_built	year_renovated	current_zoning	sq_ft_lot	prop_type	present_use
1/3/2006	698000	1	3		R1	17021 NE 113TH CT	98052	REDMOND	REDMOND	-122.1123761	47.70139	9	2810	4	2	1	0	2003	0	R4	6635	R	2
1/3/2006	649990	1	3		R1	11927 178TH PL NE	98052	REDMOND	REDMOND	-122.1022083	47.70731	9	2880	4	2	0	1	2006	0	R4	5570	R	2
1/3/2006	572500	1	3		R1	13315 174TH AVE NE	98052		REDMOND	-122.1085323	47.71986	8	2770	4	1	1	1	1987	0	R6	8444	R	2
1/3/2006	420000	1	3		R1	3303 178TH AVE NE	98052	REDMOND	REDMOND	-122.1036796	47.63914	8	1620	3	1	0	1	1968	0	R4	9600	R	2
1/3/2006	369900	1	3	15	R1	16126 NE 108TH CT	98052	REDMOND	REDMOND	-122.1241519	47.69748	7	1440	3	1	0	1	1980	0	R6	7526	R	2
1/3/2006	184667	1	15	18 51	R1	8101 229TH DR NE	98053		REDMOND	-122.0340631	47.67545	7	4160	4	2	1	1	2005	0	URPSO	7280	R	2
1/4/2006	1050000	1	3		R1	21634 NE 87TH PL	98053		REDMOND	-122.050707	47.68053	10	3960	5	3	0	1	1993	0	RA5	97574	R	2
1/4/2006	875000	1	3		R1	21404 NE 67TH ST	98053		REDMOND	-122.0555214	47.6651	10	3720	4	2	1	0	1988	0	RA5	30649	R	2
1/4/2006	660000	1	3		R1	7525 238TH AVE NE	98053		REDMOND	-122.0226818	47.67208	9	4160	4	2	1	1	1978	0	RA5	42688	R	2
1/4/2006	650000	1	3		R1	17703 NE 26TH ST	98052	REDMOND	REDMOND	-122.1039197	47.63341	8	2760	4	1	0	1	1976	0	R3	94889	R	2
1/4/2006	599950	1	3		R1	14924 NE 74TH CT	98052	REDMOND	REDMOND	-122.1411403	47.67142	9	2180	3	2	1	0	1988	0	R5	7949	R	2
1/4/2006	526787	1	3		R1	7858 148TH CT NE	98052	REDMOND	REDMOND	-122.1425247	47.67407	8	2480	3	2	1	0	2005	0	R5	2647	R	2
1/4/2006	470000	1	3		R1	17905 NE 26TH ST	98052	REDMOND	REDMOND	-122.1010258	47.63319	8	2230	4	1	0	1	1975	0	R3	12070	R	2
1/4/2006	165000	1	3		R1	2921 288TH AVE NE	98053		REDMOND	-121.9576961	47.63382	9	1850	3	2	0	0	2011	0	RA5	278891	R	2
1/5/2006	803000	1	3		R1	3624 264TH AVE NE	98053		REDMOND	-121.9856996	47.64184	10	3180	3	2	1	0	1990	0	RA5	95013	R	2
1/5/2006	507950	1	3		R1	7850 148TH CT NE	98052	REDMOND	REDMOND	-122.1424904	47.6739	8	2480	3	2	1	0	2005	0	R5	3099	R	2
1/6/2006	765000	1	3		R1	8944 237TH PL NE	98053		REDMOND	-122.0229937	47.6815	9	4000	4	2	1	1	2005	0	URPSO	7611	R	2
1/6/2006	589950	1	3		R1	11922 173RD PL NE	98052	REDMOND	REDMOND	-122.1085976	47.70678	8	2570	4	2	1	0	2005	0	R4	4737	R	2
1/9/2006	501000	1	3		R1	3201 176TH CT NE	98052	REDMOND	REDMOND	-122.1054704	47.63872	8	2620	3	1	0	2	1972	0	R4	9649	R	2
1/9/2006	372500	1	3		R1	26920 NE 50TH ST	98053		REDMOND	-121.9794764	47.65158	7	1620	3	1	0	1	1977	0	RA5	47480	R	2
1/10/2006	513262	1	3		R1	11807 242ND PL NE	98053		REDMOND	-122.0161726	47.70323	8	1930	2	2	0	0	2005	0	URPSO	4958	R	2
1/10/2006	482000	1	3		R1	9166 226TH PL NE	98053		REDMOND	-122.0376414	47.68249	7	2360	3	2	1	0	2003	0	URPSO	4080	R	2
1/11/2006	765000	1	3		R1	4811 228TH AVE NE	98053		REDMOND	-122.036513	47.65149	9	3520	4	3	0	0	1987	0	RA5	35348	R	2
1/11/2006	372500	1	3		R2	8606 134TH CT NE	98052	REDMOND	REDMOND	-122.160633	47.67987	7	1640	2	1	1	0	1986	0	R5	3279	R	2
1/11/2006	265000	1	3		R1	25149 NE PATTERSON WAY	98053		REDMOND	-122.0032387	47.65814	10	4920	4	4	1	0	2007	0	RA5	112650	R	2
1/12/2006	1392000	1	3		R1	2428 W LAKE SAMMAMISH PKWY NE	98052	REDMOND	REDMOND	-122.0878935	47.63205	9	3740	4	3	2	1	1998	0	R4	17291	R	2
1/12/2006	717390	1	3		R1	16565 NE 119TH WAY	98052	REDMOND	REDMOND	-122.1196859	47.70583	9	3090	3	2	1	0	2006	0	R4	5760	R	2
1/12/2006	552000	1	3		R1	6128 145TH CT NE	98052	REDMOND	REDMOND	-122.1463448	47.66187	9	2050	3	2	0	0	1986	0	R5	10827	R	2
1/12/2006	470000	1	3		R1	14876 NE 78TH WAY	98052	REDMOND	REDMOND	-122.1424515	47.6738	8	2120	3	2	1	0	2005	0	R5	3962	R	2
1/13/2006	523935	1	3		R1	11823 242ND PL NE	98053		REDMOND	-122.0159686	47.70348	8	1680	2	2	0	0	2005	0	URPSO	4764	R	2
1/13/2006	399900	1	3		R1	24307 NE VINE MAPLE WAY	98053		REDMOND	-122.0150839	47.70263	8	1350	2	2	0	0	2005	0	URPSO	4781	R	29
1/13/2006	335105	1	3		R1	2543 174TH AVE NE	98052	REDMOND	REDMOND	-122.1077422	47.63326	8	1690	3	2	1	0	1979	0	R5	2752	R	29
1/16/2006	572950	1	3		R1	17264 NE 119TH WAY	98052	REDMOND	REDMOND	-122.109537	47.70728	8	2530	4	2	1	0	2006	0	R4	3792	R	2
1/17/2006	949950	1	3		R1	11878 175TH PL NE	98052	REDMOND	REDMOND	-122.1056349	47.70671	10	3840	5	3	1	0	2005	0	R4	6204	R	2
1/17/2006	905000	1	3	41	R1	24215 NE 59TH LN	98053		REDMOND	-122.0144786	47.65899	10	3520	4	2	1	1	1998	0	RA2.5	46270	R	2
1/17/2006	750073	1	3		R1	12240 243RD PL NE	98053		REDMOND	-122.0147587	47.70771	8	2300	3	2	1	0	2006	0	URPSO	5697	R	2
1/17/2006	526718	1	3		R1	23844 NE ADAIR RD	98053		REDMOND	-122.0202461	47.70903	8	1680	2	2	0	0	2005	0	URPSO	6386	R	2
1/18/2006	690749	1	3		R1	12223 243RD PL NE	98053		REDMOND	-122.0154673	47.70756	8	2305	3	2	1	0	2006	0	URPSO	7583	R	2
1/18/2006	640000	1	3		R1	22233 NE 46TH ST	98053		REDMOND	-122.042431	47.64993	9	3010	4	2	0	1	1986	0	RA5	35006	R	2
1/18/2006	485000	1	3		R1	17609 NE 141ST ST	98052		REDMOND	-122.1039677	47.72588	8	1920	3	2	0	0	1986	0	R6	7560	R	2
1/18/2006	270000	1	3		R1	15918 NE 53RD ST	98052	REDMOND	REDMOND	-122.1274167	47.65571	7	2280	5	2	0	1	1966	0	R5	11180	R	2
1/19/2006	480000	1	3		R1	2600 181ST AVE NE	98052	REDMOND	REDMOND	-122.0987531	47.63293	8	2580	4	2	0	1	1972	0	R3	7600	R	2
1/19/2006	450400	1	3		R1	8727 140TH CT NE	98052	REDMOND	REDMOND	-122.1529293	47.68145	8	2080	3	1	1	1	1983	0	R5	7640	R	2
1/20/2006	462150	1	3		R1	22862 NE 128TH PL	98053		REDMOND	-122.0334802	47.71358	8	1570	2	2	0	0	2005	0	URPSO	4766	R	2