Question: Help me ASAP, use python codes 4 Merge the files site.csv and visited.csv into a single dataframe. Use the column name of site and the



Help me ASAP, use python codes
4 Merge the files site.csv and visited.csv into a single dataframe. Use the column name of site and the column site of visited. Make sure that the index labels are in order. Print the resulting dataframe. Code and Output 5 Import tuberculosis.csv. Melt the dataframe, keeping the country and year columns fixed. Print the first five lines of the melted dataframe, Code and Output A A A lat 0 1 2 3 B name O DR-1 1 DR-3 2 MSK-4 D long -49.85 -128.57 -47.15 -126.72 -48.87 -123.4 D dated 2/8/1927 ######## 1/7/1939 w N B C ident site 0 619 DR-1 1 622 DR-1 2 734 DR-3 3 735 DR-3 4 751 DR-3 5 752 DR-3 6 837 MSK-4 7 844 DR-1 4 5 ######## NaN 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 6 7 8 9 10 11 12 site visited + Ready Ready 20 1 NA ONNONNO 417 OO A 1 country 2 AD 3 AE 4 AF 5 AG 6 AL 7 AM 8 AN 9 AO 10 AR 11 AS 12 AT 13 AU 14 AZ 15 BA 16 BB 17 BD 18 BE 19 BF 20 BG 21 BH 22 BI 23 BJ 24 BM 25 BN 26 BO 27 BR 28 BS 29 BT 20 NA B D E F G H 1 year m014 m1524 m2534 m3544 m4554 m5564 m65 mu 2000 0 1 0 0 0 O NA 2000 4 4 6 5 12 10 NA 2000 228 183 149 129 94 80 NA 2000 0 0 0 0 0 1 NA 2000 19 21 14 24 19 16 NA 2000 152 130 131 63 26 21 NA 2000 0 1 2 0 0 O NA 2000 186 999 1003 912 482 312 194 NA 2000 97 278 594 402 419 368 330 NA 2000 NA NA NA NA 1 1 NA NA 2000 17 30 59 42 23 41 NA 2000 16 35 25 24 19 49 NA 2000 9 24 33 42 30 O NA 2000 4 56 82 99 66 58 77 NA 2000 0 0 2 0 0 O NA 2000 256 3640 5643 5750 4718 3667 2837 NA 2000 3 20 57 39 55 32 56 NA 2000 12 91 252 133 68 65 NA 2000 13 16 20 3 9 10 NA 2000 0 3 2 5 3 4 NA 2000 NA NA NA NA NA NA NA NA 2000 19 277 428 327 213 103 74 NA 2000 NA NA NA NA NA NA NA NA 2000 0 6 4 15 5 7 15 NA 2000 166 1182 797 518 466 340 366 NA 2000 1894 11568 11906 8623 5085 4494 NA 2000 1 2 7 9 4 3 2 NA 2000 6 65 41 30 24 12 2 NA HANA 10C CAC 100 207 11 AC ALA tuberculosis 8 L M N O Q R f014 f1524 f2534 f3544 f4554 f5564 f65 fu NA NA NA NA NA NA NA 3 16 1 3 0 0 4 NA 93 414 565 339 205 99 36 NA 1 1 1 0 0 0 O NA 3 11 10 8 8 5 11 NA 1 24 27 24 8 8 4 NA 0 0 1 0 0 1 O NA 247 1142 1091 844 200 120 NA 121 544 479 262 230 179 216 NA NA NA NA NA 1 NA NA NA 1 11 22 12 11 6 22 NA 15 19 12 15 5 14 NA 0 3 3 6 3 0 O NA 4 30 46 29 29 48 124 NA 0 0 1 0 0 0 O NA 495 3029 3238 2247 1315 778 370 NA 6 15 15 19 4 13 27 NA 7 59 128 101 45 38 14 NA 0 11 14 7 3 4 6 NA 0 1 2 0 1 1 1 NA NA NA NA NA NA NA NA NA 36 239 275 149 76 45 25 NA NA NA NA NA NA NA NA NA 0 4 6 9 6 3 4 NA 191 831 588 334 254 192 233 NA 1859 6719 7215 5395 3582 2384 2496 NA 2 5 7 8 2 3 1 NA 7 57 34 31 23 3 2 NA ACA C CT 16 ALA 274 7268 BNN E K Ready
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
