Question: The excel file shown above is raw data scraped from the tripadvisor website. it needs to be cleaned and edited before it can be used

The excel file shown above is raw data scraped from the tripadvisor website. it needs to be cleaned and edited before it can be used for machine learning. what would you change? show how you might change the first two lines. why?

 The excel file shown above is raw data scraped from the
tripadvisor website. it needs to be cleaned and edited before it can

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & Restaurant Name & stars & Reviews & Price: & Cousine Type & aty & Population \\ \hline & Eleven Madison Park & 4.5 & 230 & $25$100 & American, Edextic, French Intemational, & New York & 8,175,133 \\ \hline 2 & Levain Bakery & 4.5 & 208 & so & N/A & New York & B, 175,133 \\ \hline 3 & Le Bemardin & 4.5 & 447 & 541590 & French, Seafood & New York & 8,175,133 \\ \hline 4 & Gramercy Tavern & 4.5 & 486 & $30580 & American & New York & 2,175,133 \\ \hline 5 & Quality Meats & 4.5 & 151 & $25$100 & American, Strahhouse & New York & 8,175,133 \\ \hline 6 & L'Atelier de Joel Robuchan & 4.5 & 67 & so & French & New York & 8,175,123 \\ \hline 7 & McSorleys Oid Ne House & 4.5 & 57 & 30 & N/A & New York & 8,175,133 \\ \hline 8 & Cndle 79 & 4.5 & 92 & $31540 & Vegetarian, American, Vegan & New York & 8,175,133 \\ \hline 9 & Keens Stealhouse & 4.5 & 437 & $25$100 & N/A & New York & 8,175,133 \\ \hline 10 & Empanada Mama & 4.5 & 98 & 55510 & Colomblan, Latin South American & New York & 8,175,133 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline Restaurant Name & Stars & Reviews & Price & Cousine Type & city & Population \\ \hline 1 Eleven Madison Park & 4.5 & 230 & $25$100 & American, Eclectic, French, International, & New York & 8,175,133 \\ \hline 2 Levain Bakery & 4.5 & 208 & so & N/A & New York & 8,175,133 \\ \hline 3 Le Bernardin & 4.5 & 447 & $41$90 & French, Seafood & New York & 8,175,133 \\ \hline 4 Gramercy Tavern & 4.5 & 486 & 530580 & American & New York & 8,175,133 \\ \hline 5 Quality Meats & 4.5 & 151 & $25$100 & American, Steakhouse & New York & 8,175,133 \\ \hline 6 L'Atelier de Joel Robuchon & 4.5 & 67 & so & French & New York & 8,175,133 \\ \hline 7 McSorley Oid Ale House & 4.5 & 57 & so & N/A & New York & 8,175,133 \\ \hline 8 Candle 79 & 4.5 & 92 & $31=$40 & Vegetarian, American, Vegan & New York & B,175,133 \\ \hline 9 Keens Steakhouse & 4.5 & 437 & $25$100 & N/A & New York & 8,175,133 \\ \hline 10 Empanada Mama & 4.5 & 98 & $5$10 & Colombian, Latin, South American & New York & 8,175,133 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!