\n", " | Review_Date | \n", "Author_Name | \n", "Vehicle_Title | \n", "Review_Title | \n", "Review | \n", "Rating\\r | \n", "Car_Make | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "on 09/18/11 00:19 AM (PDT) | \n", "wizbang_fl | \n", "2007 Volkswagen New Beetle Convertible 2.5 2dr... | \n", "New Beetle- Holds up well & Fun to Drive, but ... | \n", "I've had my Beetle Convertible for over 4.5 y... | \n", "4.500 | \n", "Volkswagen | \n", "
1 | \n", "on 07/07/10 05:28 AM (PDT) | \n", "carlo frazzano | \n", "2007 Volkswagen New Beetle Convertible 2.5 PZE... | \n", "Quality Review | \n", "We bought the car new in 2007 and are general... | \n", "4.375 | \n", "Volkswagen | \n", "
2 | \n", "on 10/19/09 21:41 PM (PDT) | \n", "NewBeetleDriver | \n", "2007 Volkswagen New Beetle Convertible Triple ... | \n", "Adore it | \n", "I adore my New Beetle. Even though I'm a male... | \n", "4.375 | \n", "Volkswagen | \n", "
3 | \n", "on 01/01/09 19:13 PM (PST) | \n", "Kayemtee | \n", "2007 Volkswagen New Beetle Convertible 2.5 2dr... | \n", "Nice Ragtop | \n", "My wife chose this car to replace a Sebring c... | \n", "4.375 | \n", "Volkswagen | \n", "
4 | \n", "on 08/02/08 13:43 PM (PDT) | \n", "jik | \n", "2007 Volkswagen New Beetle Convertible 2.5 2dr... | \n", "Luv, luv, luv my dream car | \n", "4 of us carpool 1 way 30 min. Backseat ok fo... | \n", "4.750 | \n", "Volkswagen | \n", "
5 | \n", "on 05/16/08 12:07 PM (PDT) | \n", "Ray Cavanagh | \n", "2007 Volkswagen New Beetle Convertible Triple ... | \n", "The Best One So Far.... | \n", "I owned a 2002 SLK and 2003 BMW Z-4. After s... | \n", "5.000 | \n", "Volkswagen | \n", "
6 | \n", "on 03/28/08 22:04 PM (PDT) | \n", "harvestmoon | \n", "2007 Volkswagen New Beetle Convertible 2.5 2dr... | \n", "Don't Fall Under The Cute Spell! | \n", "Fell in love with the car's look and would be... | \n", "2.750 | \n", "Volkswagen | \n", "
7 | \n", "on 01/03/08 17:53 PM (PST) | \n", "The Husband | \n", "2007 Volkswagen New Beetle Convertible Triple ... | \n", "Not for Cold Weather!!! | \n", "The car is beautiful and performs well in the... | \n", "3.750 | \n", "Volkswagen | \n", "
8 | \n", "on 09/27/07 08:42 AM (PDT) | \n", "Kristina | \n", "2007 Volkswagen New Beetle Convertible 2.5 2dr... | \n", "I love my Beetle | \n", "I love my car. I previously owned an Explore... | \n", "5.000 | \n", "Volkswagen | \n", "
9 | \n", "on 08/01/07 22:24 PM (PDT) | \n", "bug lover | \n", "2007 Volkswagen New Beetle Convertible Triple ... | \n", "Bug lover review | \n", "My 2005 was so good, I had to have the Triple... | \n", "5.000 | \n", "Volkswagen | \n", "
\n", " | Review_Date | \n", "Author_Name | \n", "Vehicle_Title | \n", "Review_Title | \n", "Review | \n", "Rating\\r | \n", "
---|---|---|---|---|---|---|
Car_Make | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
AMGeneral | \n", "5 | \n", "5 | \n", "2 | \n", "5 | \n", "5 | \n", "4 | \n", "
Acura | \n", "5632 | \n", "5807 | \n", "494 | \n", "5681 | \n", "6512 | \n", "32 | \n", "
AlfaRomeo | \n", "77 | \n", "76 | \n", "22 | \n", "77 | \n", "77 | \n", "5 | \n", "
AstonMartin | \n", "82 | \n", "89 | \n", "31 | \n", "89 | \n", "89 | \n", "17 | \n", "
Audi | \n", "5069 | \n", "5389 | \n", "753 | \n", "5467 | \n", "6006 | \n", "33 | \n", "
BMW | \n", "6833 | \n", "7106 | \n", "829 | \n", "7202 | \n", "7984 | \n", "33 | \n", "
Bentley | \n", "150 | \n", "146 | \n", "39 | \n", "141 | \n", "150 | \n", "21 | \n", "
Bugatti | \n", "9 | \n", "9 | \n", "4 | \n", "9 | \n", "9 | \n", "7 | \n", "
Buick | \n", "3406 | \n", "3242 | \n", "374 | \n", "3334 | \n", "3615 | \n", "33 | \n", "
Cadillac | \n", "3539 | \n", "3531 | \n", "457 | \n", "3593 | \n", "3902 | \n", "33 | \n", "
Chevrolet | \n", "15781 | \n", "16254 | \n", "2760 | \n", "16500 | \n", "19334 | \n", "33 | \n", "
GMC | \n", "4327 | \n", "4425 | \n", "1261 | \n", "4415 | \n", "4964 | \n", "33 | \n", "
Honda | \n", "11611 | \n", "10646 | \n", "1704 | \n", "11141 | \n", "12559 | \n", "33 | \n", "
Toyota | \n", "16145 | \n", "15483 | \n", "2328 | \n", "15913 | \n", "18553 | \n", "33 | \n", "
Volkswagen | \n", "8260 | \n", "8219 | \n", "1577 | \n", "8481 | \n", "9334 | \n", "33 | \n", "
chrysler | \n", "4958 | \n", "4960 | \n", "495 | \n", "4996 | \n", "5529 | \n", "33 | \n", "
dodge | \n", "6781 | \n", "7373 | \n", "1173 | \n", "7462 | \n", "8460 | \n", "33 | \n", "
ferrari | \n", "156 | \n", "159 | \n", "47 | \n", "156 | \n", "161 | \n", "17 | \n", "
fiat | \n", "394 | \n", "380 | \n", "68 | \n", "391 | \n", "391 | \n", "25 | \n", "
ford | \n", "16908 | \n", "17136 | \n", "3261 | \n", "17718 | \n", "20576 | \n", "33 | \n", "
genesis | \n", "78 | \n", "75 | \n", "16 | \n", "78 | \n", "77 | \n", "5 | \n", "
hummer | \n", "537 | \n", "541 | \n", "35 | \n", "531 | \n", "559 | \n", "29 | \n", "
hyundai | \n", "7679 | \n", "7032 | \n", "943 | \n", "7250 | \n", "8156 | \n", "33 | \n", "
infiniti | \n", "3914 | \n", "3874 | \n", "370 | \n", "3846 | \n", "4277 | \n", "32 | \n", "
isuzu | \n", "1002 | \n", "1146 | \n", "175 | \n", "1093 | \n", "1173 | \n", "33 | \n", "
jaguar | \n", "1730 | \n", "1729 | \n", "254 | \n", "1770 | \n", "1878 | \n", "32 | \n", "
jeep | \n", "4824 | \n", "4311 | \n", "643 | \n", "4540 | \n", "4932 | \n", "33 | \n", "
kia | \n", "5561 | \n", "5225 | \n", "705 | \n", "5353 | \n", "5926 | \n", "33 | \n", "
lamborghini | \n", "83 | \n", "85 | \n", "24 | \n", "82 | \n", "86 | \n", "15 | \n", "
land-rover | \n", "1752 | \n", "1711 | \n", "186 | \n", "1743 | \n", "1831 | \n", "33 | \n", "
lexus | \n", "5371 | \n", "5474 | \n", "370 | \n", "5424 | \n", "6083 | \n", "32 | \n", "
lincoln | \n", "2801 | \n", "2776 | \n", "308 | \n", "2792 | \n", "3012 | \n", "32 | \n", "
lotus | \n", "136 | \n", "133 | \n", "16 | \n", "133 | \n", "137 | \n", "16 | \n", "
maserati | \n", "235 | \n", "234 | \n", "61 | \n", "234 | \n", "239 | \n", "25 | \n", "
maybach | \n", "24 | \n", "24 | \n", "6 | \n", "24 | \n", "24 | \n", "8 | \n", "
mazda | \n", "7165 | \n", "6830 | \n", "938 | \n", "7036 | \n", "7820 | \n", "33 | \n", "
mclaren | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
mercedes-benz | \n", "6063 | \n", "6542 | \n", "804 | \n", "6638 | \n", "7308 | \n", "33 | \n", "
mercury | \n", "3002 | \n", "3002 | \n", "291 | \n", "3037 | \n", "3355 | \n", "33 | \n", "
mini | \n", "1033 | \n", "977 | \n", "127 | \n", "997 | \n", "1036 | \n", "29 | \n", "
mitsubishi | \n", "3982 | \n", "4382 | \n", "601 | \n", "4222 | \n", "4773 | \n", "33 | \n", "
nissan | \n", "10729 | \n", "10025 | \n", "1735 | \n", "10401 | \n", "11760 | \n", "33 | \n", "
pontiac | \n", "5066 | \n", "5294 | \n", "345 | \n", "5239 | \n", "5927 | \n", "33 | \n", "
porsche | \n", "1636 | \n", "1646 | \n", "280 | \n", "1657 | \n", "1774 | \n", "30 | \n", "
ram | \n", "564 | \n", "505 | \n", "281 | \n", "551 | \n", "553 | \n", "22 | \n", "
rolls-royce | \n", "33 | \n", "34 | \n", "15 | \n", "33 | \n", "33 | \n", "11 | \n", "
subaru | \n", "5994 | \n", "5711 | \n", "970 | \n", "5958 | \n", "6510 | \n", "33 | \n", "
suzuki | \n", "2142 | \n", "2151 | \n", "460 | \n", "2124 | \n", "2326 | \n", "33 | \n", "
tesla | \n", "140 | \n", "136 | \n", "37 | \n", "139 | \n", "140 | \n", "11 | \n", "
volvo | \n", "4269 | \n", "4310 | \n", "452 | \n", "4405 | \n", "4818 | \n", "33 | \n", "
\n", " | Review_Date | \n", "Author_Name | \n", "Vehicle_Title | \n", "Review_Title | \n", "Review | \n", "Rating\\r | \n", "Car_Make | \n", "Review_Content | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.000 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
1 | \n", "on 12/18/05 19:55 PM (PST) | \n", "Clayton | \n", "2000 AM General Hummer SUV 4dr SUV AWD | \n", "HUMMER NOT A bummer | \n", "Vehicle is a beast. I don't recommend HUMMER ... | \n", "5.000 | \n", "AMGeneral | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
2 | \n", "on 01/19/06 19:46 PM (PST) | \n", "REUBEN | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "AWESOME HUMMER | \n", "Hummer is unstoppable. May only get 12 mpg bu... | \n", "5.000 | \n", "AMGeneral | \n", "AWESOME HUMMER: Hummer is unstoppable. May onl... | \n", "
3 | \n", "on 08/23/03 00:00 AM (PDT) | \n", "Bobby Keene | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "H1 Review | \n", "The truck is incredible. I have a long histo... | \n", "4.500 | \n", "AMGeneral | \n", "H1 Review: The truck is incredible. I have a ... | \n", "
4 | \n", "on 08/30/02 00:00 AM (PDT) | \n", "bluice3309 | \n", "2000 AM General Hummer SUV 4dr SUV AWD | \n", "a true ride | \n", "this beast can go through just about \\ranythi... | \n", "4.625 | \n", "AMGeneral | \n", "a true ride: this beast can go through just ab... | \n", "
\n", " | text | \n", "sentiment.label | \n", "sentiment.score | \n", "relevance | \n", "emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "count | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "waste | \n", "negative | \n", "-0.875215 | \n", "0.685741 | \n", "0.192383 | \n", "0.024961 | \n", "0.313145 | \n", "0.083320 | \n", "0.277825 | \n", "1 | \n", "
1 | \n", "fire | \n", "negative | \n", "-0.934513 | \n", "0.598326 | \n", "0.360925 | \n", "0.002355 | \n", "0.266490 | \n", "0.069938 | \n", "0.442759 | \n", "1 | \n", "
2 | \n", "car | \n", "negative | \n", "-0.844774 | \n", "0.581432 | \n", "0.144346 | \n", "0.150177 | \n", "0.246102 | \n", "0.061760 | \n", "0.203999 | \n", "2 | \n", "
3 | \n", "hell | \n", "negative | \n", "-0.934513 | \n", "0.577011 | \n", "0.360925 | \n", "0.002355 | \n", "0.266490 | \n", "0.069938 | \n", "0.442759 | \n", "1 | \n", "
4 | \n", "year | \n", "negative | \n", "-0.875215 | \n", "0.563676 | \n", "0.192383 | \n", "0.024961 | \n", "0.313145 | \n", "0.083320 | \n", "0.277825 | \n", "1 | \n", "
5 | \n", "time | \n", "neutral | \n", "0.000000 | \n", "0.466983 | \n", "0.266573 | \n", "0.401314 | \n", "0.089080 | \n", "0.024027 | \n", "0.065767 | \n", "1 | \n", "
\n", " | text | \n", "sentiment.label | \n", "sentiment.score | \n", "relevance | \n", "emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "count | \n", "0 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "waste | \n", "negative | \n", "-0.875215 | \n", "0.685741 | \n", "0.192383 | \n", "0.024961 | \n", "0.313145 | \n", "0.083320 | \n", "0.277825 | \n", "1 | \n", "What a waste: I have owned this car for a year... | \n", "
1 | \n", "fire | \n", "negative | \n", "-0.934513 | \n", "0.598326 | \n", "0.360925 | \n", "0.002355 | \n", "0.266490 | \n", "0.069938 | \n", "0.442759 | \n", "1 | \n", "What a waste: I have owned this car for a year... | \n", "
2 | \n", "car | \n", "negative | \n", "-0.844774 | \n", "0.581432 | \n", "0.144346 | \n", "0.150177 | \n", "0.246102 | \n", "0.061760 | \n", "0.203999 | \n", "2 | \n", "What a waste: I have owned this car for a year... | \n", "
3 | \n", "hell | \n", "negative | \n", "-0.934513 | \n", "0.577011 | \n", "0.360925 | \n", "0.002355 | \n", "0.266490 | \n", "0.069938 | \n", "0.442759 | \n", "1 | \n", "What a waste: I have owned this car for a year... | \n", "
4 | \n", "year | \n", "negative | \n", "-0.875215 | \n", "0.563676 | \n", "0.192383 | \n", "0.024961 | \n", "0.313145 | \n", "0.083320 | \n", "0.277825 | \n", "1 | \n", "What a waste: I have owned this car for a year... | \n", "
5 | \n", "time | \n", "neutral | \n", "0.000000 | \n", "0.466983 | \n", "0.266573 | \n", "0.401314 | \n", "0.089080 | \n", "0.024027 | \n", "0.065767 | \n", "1 | \n", "What a waste: I have owned this car for a year... | \n", "
\n", " | text | \n", "sentiment.label | \n", "sentiment.score | \n", "relevance | \n", "emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "count | \n", "Review_Date | \n", "Author_Name | \n", "Vehicle_Title | \n", "Review_Title | \n", "Review | \n", "Rating\\r | \n", "Car_Make | \n", "Review_Content | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "waste | \n", "negative | \n", "-0.875215 | \n", "0.685741 | \n", "0.192383 | \n", "0.024961 | \n", "0.313145 | \n", "0.083320 | \n", "0.277825 | \n", "1 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
1 | \n", "fire | \n", "negative | \n", "-0.934513 | \n", "0.598326 | \n", "0.360925 | \n", "0.002355 | \n", "0.266490 | \n", "0.069938 | \n", "0.442759 | \n", "1 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
2 | \n", "car | \n", "negative | \n", "-0.844774 | \n", "0.581432 | \n", "0.144346 | \n", "0.150177 | \n", "0.246102 | \n", "0.061760 | \n", "0.203999 | \n", "2 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
3 | \n", "hell | \n", "negative | \n", "-0.934513 | \n", "0.577011 | \n", "0.360925 | \n", "0.002355 | \n", "0.266490 | \n", "0.069938 | \n", "0.442759 | \n", "1 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
4 | \n", "year | \n", "negative | \n", "-0.875215 | \n", "0.563676 | \n", "0.192383 | \n", "0.024961 | \n", "0.313145 | \n", "0.083320 | \n", "0.277825 | \n", "1 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
5 | \n", "time | \n", "neutral | \n", "0.000000 | \n", "0.466983 | \n", "0.266573 | \n", "0.401314 | \n", "0.089080 | \n", "0.024027 | \n", "0.065767 | \n", "1 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
\n", " | text | \n", "sentiment.label | \n", "sentiment.score | \n", "relevance | \n", "emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "count | \n", "0 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "waste | \n", "negative | \n", "-0.875215 | \n", "0.685741 | \n", "0.192383 | \n", "0.024961 | \n", "0.313145 | \n", "0.083320 | \n", "0.277825 | \n", "1.0 | \n", "What a waste: I have owned this car for a year... | \n", "
1 | \n", "fire | \n", "negative | \n", "-0.934513 | \n", "0.598326 | \n", "0.360925 | \n", "0.002355 | \n", "0.266490 | \n", "0.069938 | \n", "0.442759 | \n", "1.0 | \n", "What a waste: I have owned this car for a year... | \n", "
2 | \n", "car | \n", "negative | \n", "-0.844774 | \n", "0.581432 | \n", "0.144346 | \n", "0.150177 | \n", "0.246102 | \n", "0.061760 | \n", "0.203999 | \n", "2.0 | \n", "What a waste: I have owned this car for a year... | \n", "
3 | \n", "hell | \n", "negative | \n", "-0.934513 | \n", "0.577011 | \n", "0.360925 | \n", "0.002355 | \n", "0.266490 | \n", "0.069938 | \n", "0.442759 | \n", "1.0 | \n", "What a waste: I have owned this car for a year... | \n", "
4 | \n", "year | \n", "negative | \n", "-0.875215 | \n", "0.563676 | \n", "0.192383 | \n", "0.024961 | \n", "0.313145 | \n", "0.083320 | \n", "0.277825 | \n", "1.0 | \n", "What a waste: I have owned this car for a year... | \n", "
5 | \n", "time | \n", "neutral | \n", "0.000000 | \n", "0.466983 | \n", "0.266573 | \n", "0.401314 | \n", "0.089080 | \n", "0.024027 | \n", "0.065767 | \n", "1.0 | \n", "What a waste: I have owned this car for a year... | \n", "
0 | \n", "Top speed | \n", "negative | \n", "-0.537564 | \n", "0.881037 | \n", "0.509224 | \n", "0.199172 | \n", "0.038777 | \n", "0.065161 | \n", "0.044472 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
1 | \n", "OK cause | \n", "positive | \n", "0.647515 | \n", "0.786985 | \n", "0.063022 | \n", "0.432975 | \n", "0.107965 | \n", "0.016918 | \n", "0.090944 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
2 | \n", "HUMMER H | \n", "neutral | \n", "0.000000 | \n", "0.639671 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
3 | \n", "seat cushion | \n", "negative | \n", "-0.537564 | \n", "0.593566 | \n", "0.509224 | \n", "0.199172 | \n", "0.038777 | \n", "0.065161 | \n", "0.044472 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
4 | \n", "HUMMER | \n", "negative | \n", "-0.913874 | \n", "0.582162 | \n", "0.172604 | \n", "0.221188 | \n", "0.146469 | \n", "0.022002 | \n", "0.029588 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
5 | \n", "speed | \n", "positive | \n", "0.305110 | \n", "0.548092 | \n", "0.286123 | \n", "0.316074 | \n", "0.073371 | \n", "0.041039 | \n", "0.067708 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
6 | \n", "thing | \n", "negative | \n", "-0.949193 | \n", "0.534867 | \n", "0.645165 | \n", "0.010028 | \n", "0.216581 | \n", "0.022772 | \n", "0.055427 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
7 | \n", "Vehicle | \n", "negative | \n", "-0.961235 | \n", "0.531410 | \n", "0.180207 | \n", "0.061332 | \n", "0.192902 | \n", "0.008274 | \n", "0.046232 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
8 | \n", "beast | \n", "negative | \n", "-0.961235 | \n", "0.524488 | \n", "0.180207 | \n", "0.061332 | \n", "0.192902 | \n", "0.008274 | \n", "0.046232 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
9 | \n", "thats | \n", "positive | \n", "0.647515 | \n", "0.462435 | \n", "0.063022 | \n", "0.432975 | \n", "0.107965 | \n", "0.016918 | \n", "0.090944 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
10 | \n", "bummer | \n", "negative | \n", "-0.961235 | \n", "0.360189 | \n", "0.180207 | \n", "0.061332 | \n", "0.192902 | \n", "0.008274 | \n", "0.046232 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
11 | \n", "average | \n", "negative | \n", "-0.857270 | \n", "0.341687 | \n", "0.165002 | \n", "0.381043 | \n", "0.100036 | \n", "0.035730 | \n", "0.012944 | \n", "1.0 | \n", "HUMMER NOT A bummer : Vehicle is a beast. I do... | \n", "
0 | \n", "AWESOME HUMMER | \n", "positive | \n", "0.734682 | \n", "0.833177 | \n", "0.032499 | \n", "0.493942 | \n", "0.116809 | \n", "0.009257 | \n", "0.024046 | \n", "1.0 | \n", "AWESOME HUMMER: Hummer is unstoppable. May onl... | \n", "
1 | \n", "mph | \n", "neutral | \n", "0.000000 | \n", "0.635404 | \n", "0.499977 | \n", "0.151388 | \n", "0.039640 | \n", "0.036049 | \n", "0.064654 | \n", "1.0 | \n", "AWESOME HUMMER: Hummer is unstoppable. May onl... | \n", "
\n", " | text | \n", "sentiment.label | \n", "sentiment.score | \n", "relevance | \n", "emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "count | \n", "Review_Date | \n", "Author_Name | \n", "Vehicle_Title | \n", "Review_Title | \n", "Review | \n", "Rating\\r | \n", "Car_Make | \n", "Review_Content | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "waste | \n", "negative | \n", "-0.875215 | \n", "0.685741 | \n", "0.192383 | \n", "0.024961 | \n", "0.313145 | \n", "0.083320 | \n", "0.277825 | \n", "1.0 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
1 | \n", "fire | \n", "negative | \n", "-0.934513 | \n", "0.598326 | \n", "0.360925 | \n", "0.002355 | \n", "0.266490 | \n", "0.069938 | \n", "0.442759 | \n", "1.0 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
2 | \n", "car | \n", "negative | \n", "-0.844774 | \n", "0.581432 | \n", "0.144346 | \n", "0.150177 | \n", "0.246102 | \n", "0.061760 | \n", "0.203999 | \n", "2.0 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
3 | \n", "hell | \n", "negative | \n", "-0.934513 | \n", "0.577011 | \n", "0.360925 | \n", "0.002355 | \n", "0.266490 | \n", "0.069938 | \n", "0.442759 | \n", "1.0 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
4 | \n", "year | \n", "negative | \n", "-0.875215 | \n", "0.563676 | \n", "0.192383 | \n", "0.024961 | \n", "0.313145 | \n", "0.083320 | \n", "0.277825 | \n", "1.0 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
5 | \n", "time | \n", "neutral | \n", "0.000000 | \n", "0.466983 | \n", "0.266573 | \n", "0.401314 | \n", "0.089080 | \n", "0.024027 | \n", "0.065767 | \n", "1.0 | \n", "on 06/15/02 00:00 AM (PDT) | \n", "mike6382 | \n", "2000 AM General Hummer SUV Hard Top 4dr SUV AWD | \n", "What a waste | \n", "I have owned this car for a year and a \\rhalf... | \n", "1.0 | \n", "AMGeneral | \n", "What a waste: I have owned this car for a year... | \n", "
\n", " | emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "sentiment.score | \n", "Rating\\r | \n", "
---|---|---|---|---|---|---|---|
Review_Title | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
1 sweet R32 | \n", "0.151543 | \n", "0.532162 | \n", "0.067859 | \n", "0.018501 | \n", "0.112994 | \n", "0.649825 | \n", "4.875 | \n", "
2002 Trans Am/Sunset Orange Metallic | \n", "0.176322 | \n", "0.465210 | \n", "0.257064 | \n", "0.032842 | \n", "0.038908 | \n", "0.148035 | \n", "4.625 | \n", "
42 days of driving 8 days in the shop | \n", "0.206478 | \n", "0.563466 | \n", "0.114506 | \n", "0.010082 | \n", "0.082325 | \n", "-0.054126 | \n", "3.375 | \n", "
A great little car | \n", "0.278575 | \n", "0.470586 | \n", "0.063823 | \n", "0.015218 | \n", "0.039688 | \n", "0.503785 | \n", "4.875 | \n", "
AWESOME FUN MY LITTLE TIGER | \n", "0.007629 | \n", "0.628312 | \n", "0.013015 | \n", "0.001452 | \n", "0.024782 | \n", "0.986029 | \n", "5.000 | \n", "
I LOVE my Focus | \n", "0.074019 | \n", "0.589196 | \n", "0.111722 | \n", "0.008124 | \n", "0.066092 | \n", "0.621983 | \n", "4.750 | \n", "
Looks Good But Hunk Of Junk | \n", "0.144671 | \n", "0.061358 | \n", "0.060613 | \n", "0.050494 | \n", "0.116835 | \n", "-0.984622 | \n", "2.875 | \n", "
Mr TACOMA | \n", "0.122766 | \n", "0.825653 | \n", "0.034777 | \n", "0.023124 | \n", "0.030344 | \n", "0.633803 | \n", "5.000 | \n", "
Veracruz | \n", "0.106981 | \n", "0.524371 | \n", "0.091482 | \n", "0.012344 | \n", "0.054493 | \n", "0.591816 | \n", "4.750 | \n", "
You will pay for that warranty | \n", "0.396306 | \n", "0.110458 | \n", "0.056980 | \n", "0.021192 | \n", "0.119030 | \n", "-0.373583 | \n", "2.750 | \n", "
everyday rSx | \n", "0.038486 | \n", "0.515852 | \n", "0.133419 | \n", "0.008035 | \n", "0.033998 | \n", "0.677286 | \n", "4.000 | \n", "
got new weel | \n", "0.108507 | \n", "0.348390 | \n", "0.079194 | \n", "0.034643 | \n", "0.239177 | \n", "0.654034 | \n", "4.625 | \n", "
i'm on my second one | \n", "0.063124 | \n", "0.024840 | \n", "0.053951 | \n", "0.026402 | \n", "0.165089 | \n", "-0.973446 | \n", "5.000 | \n", "
! un happy Camper | \n", "0.424926 | \n", "0.219506 | \n", "0.066627 | \n", "0.036578 | \n", "0.084982 | \n", "-0.388182 | \n", "2.625 | \n", "
\"\"\"I can't believe it \"\" | \n", "0.244671 | \n", "0.025868 | \n", "0.053133 | \n", "0.067597 | \n", "0.165597 | \n", "-0.904022 | \n", "1.000 | \n", "
\"06\" GTO | \n", "0.102005 | \n", "0.632400 | \n", "0.113796 | \n", "0.055768 | \n", "0.067348 | \n", "0.759998 | \n", "5.000 | \n", "
\"Acceleration failure\" - Genesis phraseology | \n", "0.139895 | \n", "0.143780 | \n", "0.259497 | \n", "0.049344 | \n", "0.086211 | \n", "-0.632639 | \n", "3.000 | \n", "
\"Cry wolf\" tire light and redundant warning screen | \n", "0.304694 | \n", "0.165782 | \n", "0.128762 | \n", "0.043923 | \n", "0.172683 | \n", "-0.744237 | \n", "3.000 | \n", "
\"Downgraded\" to an LS 430 but best upgrade ever! | \n", "0.381772 | \n", "0.401842 | \n", "0.028101 | \n", "0.018007 | \n", "0.026035 | \n", "0.480924 | \n", "5.000 | \n", "
\"First Ride\" Impressions when I visited Tesla's Factory | \n", "0.231870 | \n", "0.443138 | \n", "0.036262 | \n", "0.023640 | \n", "0.051412 | \n", "0.610619 | \n", "4.875 | \n", "
\n", " | emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "sentiment.score | \n", "Rating\r", " | \n", "
---|---|---|---|---|---|---|---|
emotion.sadness | \n", "1.000000 | \n", "-0.635496 | \n", "0.099018 | \n", "0.062068 | \n", "0.158305 | \n", "-0.519823 | \n", "-0.353612 | \n", "
emotion.joy | \n", "-0.635496 | \n", "1.000000 | \n", "-0.391679 | \n", "-0.226616 | \n", "-0.484740 | \n", "0.761211 | \n", "0.518204 | \n", "
emotion.fear | \n", "0.099018 | \n", "-0.391679 | \n", "1.000000 | \n", "0.077824 | \n", "0.149845 | \n", "-0.321152 | \n", "-0.187657 | \n", "
emotion.disgust | \n", "0.062068 | \n", "-0.226616 | \n", "0.077824 | \n", "1.000000 | \n", "0.136611 | \n", "-0.213541 | \n", "-0.155754 | \n", "
emotion.anger | \n", "0.158305 | \n", "-0.484740 | \n", "0.149845 | \n", "0.136611 | \n", "1.000000 | \n", "-0.440811 | \n", "-0.352083 | \n", "
sentiment.score | \n", "-0.519823 | \n", "0.761211 | \n", "-0.321152 | \n", "-0.213541 | \n", "-0.440811 | \n", "1.000000 | \n", "0.620320 | \n", "
Rating\r", " | \n", "-0.353612 | \n", "0.518204 | \n", "-0.187657 | \n", "-0.155754 | \n", "-0.352083 | \n", "0.620320 | \n", "1.000000 | \n", "
LinearRegression()In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
LinearRegression()
\n", " | emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "sentiment.score | \n", "
---|---|---|---|---|---|---|
Review_Title | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
1 sweet R32 | \n", "0.151543 | \n", "0.532162 | \n", "0.067859 | \n", "0.018501 | \n", "0.112994 | \n", "0.649825 | \n", "
2002 Trans Am/Sunset Orange Metallic | \n", "0.176322 | \n", "0.465210 | \n", "0.257064 | \n", "0.032842 | \n", "0.038908 | \n", "0.148035 | \n", "
42 days of driving 8 days in the shop | \n", "0.206478 | \n", "0.563466 | \n", "0.114506 | \n", "0.010082 | \n", "0.082325 | \n", "-0.054126 | \n", "
A great little car | \n", "0.278575 | \n", "0.470586 | \n", "0.063823 | \n", "0.015218 | \n", "0.039688 | \n", "0.503785 | \n", "
AWESOME FUN MY LITTLE TIGER | \n", "0.007629 | \n", "0.628312 | \n", "0.013015 | \n", "0.001452 | \n", "0.024782 | \n", "0.986029 | \n", "
LinearRegression()In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
LinearRegression()
\n", " | Predicted Rating | \n", "Actual Rating | \n", "
---|---|---|
0 | \n", "4.300783 | \n", "4.875 | \n", "
1 | \n", "3.895731 | \n", "4.625 | \n", "
2 | \n", "4.342326 | \n", "3.375 | \n", "
3 | \n", "4.705346 | \n", "4.875 | \n", "
4 | \n", "3.256459 | \n", "5.000 | \n", "
... | \n", "... | \n", "... | \n", "
1527 | \n", "4.623339 | \n", "3.125 | \n", "
1528 | \n", "3.747142 | \n", "5.000 | \n", "
1529 | \n", "3.874102 | \n", "4.500 | \n", "
1530 | \n", "3.468226 | \n", "3.875 | \n", "
1531 | \n", "4.406095 | \n", "5.000 | \n", "
1532 rows Ć 2 columns
\n", "RandomForestRegressor(random_state=0)In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
RandomForestRegressor(random_state=0)
\n", " | sentiment.score | \n", "emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "Rating\\r | \n", "Car_Make | \n", "Review_Content | \n", "
---|---|---|---|---|---|---|---|---|---|
Review_Title | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
1 sweet R32 | \n", "0.649825 | \n", "0.151543 | \n", "0.532162 | \n", "0.067859 | \n", "0.018501 | \n", "0.112994 | \n", "4.875 | \n", "Volkswagen | \n", "1 sweet R32: I was looking into buying a Subaru WRX \\rSTI, but after two test drives in each \\rand reading as many \\rRoad&Track,Car&Driver,and any other \\rinfo I could find I desided to go with \\rthe R32. I traded in my 2003 GTI VR6 \\rthat had 29,000 miles on it. That was a \\rgreat car but this is a whole new \\rbeast. Once you own an all wheel drive \\rthere is just no going back. This car \\rhandles like a dream, the seats are the \\rbest I've ever been in. Cabin is put \\rtogether very well and the pipes are \\rcrazy. The climit control is awsome, \\rheated seats are so sweet on those cold \\rwinter days. I live in the central \\rvalley of California so these tire are \\rthe best. If there was one thing I \\rwould change(give me a spare tire)!!!!! | \n", "
2002 Trans Am/Sunset Orange Metallic | \n", "0.148035 | \n", "0.176322 | \n", "0.465210 | \n", "0.257064 | \n", "0.032842 | \n", "0.038908 | \n", "4.625 | \n", "pontiac | \n", "2002 Trans Am/Sunset Orange Metallic: This Is Pontiac's most exciting vehicle \\rof all time.It has so much performance \\rthat it is a big disapointment that it \\rwill be discontinued this year.The only \\rarea that this vehicle does not excell \\rin would be the fuel economy \\rdepartment.I guess that if you can \\rafford one of these dream cars, you \\rreally dony worry about how far it will \\rtravel on a tankfull of gas. | \n", "
42 days of driving 8 days in the shop | \n", "-0.054126 | \n", "0.206478 | \n", "0.563466 | \n", "0.114506 | \n", "0.010082 | \n", "0.082325 | \n", "3.375 | \n", "chrysler | \n", "42 days of driving 8 days in the shop : I was given the sebring for my 20th wedding anniversary. I have been in love with it for years and finally got it. After 42 days I blew most of the electrical system. It has been at the dealer for 8 days and they can not find the problem. Right now I am not very happy. | \n", "
A great little car | \n", "0.503785 | \n", "0.278575 | \n", "0.470586 | \n", "0.063823 | \n", "0.015218 | \n", "0.039688 | \n", "4.875 | \n", "kia | \n", "A great little car: Bought my Spectra about one year ago, currently has about 18,000 miles on it. I have had absolutely no problems with it. I had cruise control added at the time of purchase, other than that it's stock. This is my daily driver, it's comfortable, reliable and gets decent mileage. The Spectra happens to be my second Kia, I have a Sedona van that has been to the dealer several times (however everything was covered by the warranty) it currently has 58,000 miles on it. The Spectra's a great handling car. | \n", "
AWESOME FUN MY LITTLE TIGER | \n", "0.986029 | \n", "0.007629 | \n", "0.628312 | \n", "0.013015 | \n", "0.001452 | \n", "0.024782 | \n", "5.000 | \n", "fiat | \n", "AWESOME FUN MY LITTLE TIGER: Abarth is ultimately more fun than my old mustang or Z a little power house that doesn't shy away from a fight love the engine growl and the kick more room than you think awesome bang for the buck .Fun the most fun than any car I have ever own worth every penny a pleasure to drive. | \n", "
I LOVE my Focus | \n", "0.621983 | \n", "0.074019 | \n", "0.589196 | \n", "0.111722 | \n", "0.008124 | \n", "0.066092 | \n", "4.750 | \n", "ford | \n", "I LOVE my Focus: I LOVE my Focus. I've had it about 2 \\ryears. It drives great, looks good, \\rgets great gas milage and never slows \\rdown. I'm even thinking of getting \\ranother one on my next car purchase! | \n", "
Looks Good But Hunk Of Junk | \n", "-0.984622 | \n", "0.144671 | \n", "0.061358 | \n", "0.060613 | \n", "0.050494 | \n", "0.116835 | \n", "2.875 | \n", "maserati | \n", "Looks Good But Hunk Of Junk: This car is strictly \"looks only\", it is not reliable or even close to it.I have already sank $13,760 in repairs at only 23K miles.This is totally unacceptable for a $140K car when new.I am taking it to the auction next week to \"unload\" before it can empty my wallet again.But if you want a sharp car that sits good in the driveway - this is it!Just don't drive it anywhere!! | \n", "
Mr TACOMA | \n", "0.633803 | \n", "0.122766 | \n", "0.825653 | \n", "0.034777 | \n", "0.023124 | \n", "0.030344 | \n", "5.000 | \n", "Toyota | \n", "Mr TACOMA: Great truck. The Handling is pretty \\rnice and the engine is stronger. The V6 \\rwith 3100 pounds can really make this \\rtruck move. | \n", "
Veracruz | \n", "0.591816 | \n", "0.106981 | \n", "0.524371 | \n", "0.091482 | \n", "0.012344 | \n", "0.054493 | \n", "4.750 | \n", "hyundai | \n", "Veracruz: This is a crossover with the ride of a cruse ship. The car has so many bells and whistles. Have it one week and already over 1100 miles. Finding wonderful things about it every day. Could be the best car ever. | \n", "
You will pay for that warranty | \n", "-0.373583 | \n", "0.396306 | \n", "0.110458 | \n", "0.056980 | \n", "0.021192 | \n", "0.119030 | \n", "2.750 | \n", "kia | \n", "You will pay for that warranty: Own a 2002 KIA Sedona EX. I complained about lights going dim while under warranty. Kia checked, said everything within parameters. Guess what, 3000 miles out of warranty alternator died. KIA says it's on you now. 63,000 miles and they want $565.00 to repair; that includes alternator, belts and labor. It's not a repair you can do either, seems AC lines are in the way. Do you think KIA planned it? Ask them about changing spark plugs the rear 3, seems you need to remove the air intake manifold? That will require new gaskets? Not sure of that cost. I hope to dump this Sedona by then! Think twice before you buy, they will get you to pay for that supposedly free 5year/60000 bumper to bumper warranty. RIPOFF. | \n", "
\n", " | emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "sentiment.score | \n", "Rating\\r | \n", "Predicted_Y | \n", "
---|---|---|---|---|---|---|---|---|
\n", " | mean | \n", "mean | \n", "mean | \n", "mean | \n", "mean | \n", "mean | \n", "mean | \n", "mean | \n", "
Car_Make | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
AMGeneral | \n", "0.233502 | \n", "0.416527 | \n", "0.149416 | \n", "0.030530 | \n", "0.065171 | \n", "0.021626 | \n", "4.833333 | \n", "4.264005 | \n", "
Acura | \n", "0.186803 | \n", "0.467307 | \n", "0.134082 | \n", "0.020744 | \n", "0.064254 | \n", "0.330192 | \n", "4.538690 | \n", "4.455716 | \n", "
AlfaRomeo | \n", "0.179048 | \n", "0.434307 | \n", "0.101048 | \n", "0.030507 | \n", "0.088323 | \n", "0.268080 | \n", "4.187500 | \n", "4.435494 | \n", "
AstonMartin | \n", "0.161465 | \n", "0.532924 | \n", "0.093979 | \n", "0.030943 | \n", "0.063027 | \n", "0.470149 | \n", "4.613636 | \n", "4.631018 | \n", "
Audi | \n", "0.196609 | \n", "0.490965 | \n", "0.092430 | \n", "0.021402 | \n", "0.059860 | \n", "0.303431 | \n", "4.453431 | \n", "4.421119 | \n", "
BMW | \n", "0.191940 | \n", "0.474563 | \n", "0.086499 | \n", "0.024038 | \n", "0.072675 | \n", "0.243201 | \n", "4.468750 | \n", "4.354955 | \n", "
Bentley | \n", "0.187771 | \n", "0.528449 | \n", "0.089768 | \n", "0.028513 | \n", "0.057980 | \n", "0.441103 | \n", "4.239583 | \n", "4.57587 | \n", "
Bugatti | \n", "0.188314 | \n", "0.587727 | \n", "0.055366 | \n", "0.023677 | \n", "0.054105 | \n", "0.430882 | \n", "4.750000 | \n", "4.718716 | \n", "
Buick | \n", "0.260452 | \n", "0.392718 | \n", "0.099129 | \n", "0.025511 | \n", "0.086554 | \n", "0.088404 | \n", "4.162736 | \n", "4.075432 | \n", "
Cadillac | \n", "0.218803 | \n", "0.429976 | \n", "0.102534 | \n", "0.030479 | \n", "0.069962 | \n", "0.274075 | \n", "4.395408 | \n", "4.335975 | \n", "
Chevrolet | \n", "0.200984 | \n", "0.441252 | \n", "0.102457 | \n", "0.037943 | \n", "0.074343 | \n", "0.173096 | \n", "4.104730 | \n", "4.23044 | \n", "
GMC | \n", "0.218755 | \n", "0.416075 | \n", "0.111135 | \n", "0.033378 | \n", "0.067579 | \n", "0.071438 | \n", "4.089912 | \n", "4.138499 | \n", "
Honda | \n", "0.191337 | \n", "0.418301 | \n", "0.117569 | \n", "0.029766 | \n", "0.063076 | \n", "0.118789 | \n", "3.832386 | \n", "4.130003 | \n", "
Toyota | \n", "0.199025 | \n", "0.431638 | \n", "0.104728 | \n", "0.027125 | \n", "0.070333 | \n", "0.154561 | \n", "4.350543 | \n", "4.243079 | \n", "
Volkswagen | \n", "0.190767 | \n", "0.429078 | \n", "0.126892 | \n", "0.031965 | \n", "0.071180 | \n", "0.130390 | \n", "4.396875 | \n", "4.17746 | \n", "
chrysler | \n", "0.234828 | \n", "0.398700 | \n", "0.116330 | \n", "0.035023 | \n", "0.075663 | \n", "0.086065 | \n", "4.140957 | \n", "4.168451 | \n", "
dodge | \n", "0.218513 | \n", "0.408767 | \n", "0.119761 | \n", "0.026407 | \n", "0.076249 | \n", "0.100277 | \n", "4.133929 | \n", "4.163826 | \n", "
ferrari | \n", "0.159649 | \n", "0.539798 | \n", "0.108343 | \n", "0.019731 | \n", "0.082763 | \n", "0.463863 | \n", "4.767241 | \n", "4.530158 | \n", "
fiat | \n", "0.203202 | \n", "0.401303 | \n", "0.100537 | \n", "0.030897 | \n", "0.076235 | \n", "0.087065 | \n", "3.818878 | \n", "4.134359 | \n", "
ford | \n", "0.238288 | \n", "0.362188 | \n", "0.121460 | \n", "0.028063 | \n", "0.088316 | \n", "0.078135 | \n", "4.040094 | \n", "4.005134 | \n", "
genesis | \n", "0.211237 | \n", "0.430926 | \n", "0.078043 | \n", "0.031972 | \n", "0.057856 | \n", "0.156253 | \n", "4.608696 | \n", "4.316763 | \n", "
hummer | \n", "0.181750 | \n", "0.502888 | \n", "0.126320 | \n", "0.027008 | \n", "0.055950 | \n", "0.297203 | \n", "4.404605 | \n", "4.462752 | \n", "
hyundai | \n", "0.220990 | \n", "0.393721 | \n", "0.096735 | \n", "0.027251 | \n", "0.079915 | \n", "0.161732 | \n", "4.109375 | \n", "4.14899 | \n", "
infiniti | \n", "0.200538 | \n", "0.469661 | \n", "0.090667 | \n", "0.024671 | \n", "0.059761 | \n", "0.322187 | \n", "4.566860 | \n", "4.393907 | \n", "
isuzu | \n", "0.201127 | \n", "0.404813 | \n", "0.122677 | \n", "0.028856 | \n", "0.101334 | \n", "0.205943 | \n", "4.220238 | \n", "4.306578 | \n", "
jaguar | \n", "0.163703 | \n", "0.556705 | \n", "0.086785 | \n", "0.025675 | \n", "0.055537 | \n", "0.375661 | \n", "4.584091 | \n", "4.497573 | \n", "
jeep | \n", "0.253255 | \n", "0.396047 | \n", "0.104165 | \n", "0.025074 | \n", "0.079216 | \n", "0.106891 | \n", "4.108607 | \n", "4.15378 | \n", "
kia | \n", "0.266675 | \n", "0.394792 | \n", "0.111849 | \n", "0.025904 | \n", "0.070382 | \n", "0.141621 | \n", "4.141827 | \n", "4.12064 | \n", "
lamborghini | \n", "0.127094 | \n", "0.629176 | \n", "0.082221 | \n", "0.029788 | \n", "0.052919 | \n", "0.657044 | \n", "4.725000 | \n", "4.665769 | \n", "
land-rover | \n", "0.274524 | \n", "0.355115 | \n", "0.109827 | \n", "0.034846 | \n", "0.086169 | \n", "0.080642 | \n", "3.848837 | \n", "4.0177 | \n", "
lexus | \n", "0.202997 | \n", "0.439800 | \n", "0.100562 | \n", "0.031977 | \n", "0.076374 | \n", "0.231606 | \n", "4.306122 | \n", "4.294433 | \n", "
lincoln | \n", "0.213433 | \n", "0.466320 | \n", "0.112260 | \n", "0.027192 | \n", "0.075736 | \n", "0.163414 | \n", "4.269231 | \n", "4.264042 | \n", "
lotus | \n", "0.158467 | \n", "0.457916 | \n", "0.137350 | \n", "0.023458 | \n", "0.080445 | \n", "0.307135 | \n", "4.702381 | \n", "4.490183 | \n", "
maserati | \n", "0.174925 | \n", "0.523992 | \n", "0.087822 | \n", "0.037616 | \n", "0.071795 | \n", "0.311256 | \n", "4.431250 | \n", "4.394369 | \n", "
maybach | \n", "0.178194 | \n", "0.515520 | \n", "0.077657 | \n", "0.015687 | \n", "0.072357 | \n", "0.633714 | \n", "4.958333 | \n", "4.733771 | \n", "
mazda | \n", "0.203442 | \n", "0.444971 | \n", "0.111021 | \n", "0.026170 | \n", "0.062387 | \n", "0.230268 | \n", "4.479651 | \n", "4.318612 | \n", "
mercedes-benz | \n", "0.227015 | \n", "0.387488 | \n", "0.105910 | \n", "0.026781 | \n", "0.085045 | \n", "0.091385 | \n", "4.095745 | \n", "4.094125 | \n", "
mercury | \n", "0.200664 | \n", "0.462219 | \n", "0.105958 | \n", "0.025067 | \n", "0.063838 | \n", "0.246360 | \n", "4.311224 | \n", "4.390451 | \n", "
mini | \n", "0.218531 | \n", "0.443708 | \n", "0.096154 | \n", "0.026429 | \n", "0.071672 | \n", "0.167861 | \n", "4.036184 | \n", "4.190949 | \n", "
mitsubishi | \n", "0.175781 | \n", "0.481554 | \n", "0.118347 | \n", "0.025169 | \n", "0.070454 | \n", "0.300219 | \n", "4.346698 | \n", "4.417798 | \n", "
nissan | \n", "0.241268 | \n", "0.373916 | \n", "0.111114 | \n", "0.034341 | \n", "0.079956 | \n", "0.102161 | \n", "4.247093 | \n", "4.119348 | \n", "
pontiac | \n", "0.190257 | \n", "0.430994 | \n", "0.110610 | \n", "0.026520 | \n", "0.078449 | \n", "0.165777 | \n", "4.375000 | \n", "4.221752 | \n", "
porsche | \n", "0.145226 | \n", "0.510727 | \n", "0.093447 | \n", "0.026101 | \n", "0.080697 | \n", "0.382931 | \n", "4.662500 | \n", "4.552274 | \n", "
ram | \n", "0.240626 | \n", "0.367544 | \n", "0.108349 | \n", "0.040745 | \n", "0.076267 | \n", "0.000294 | \n", "3.861111 | \n", "4.113366 | \n", "
rolls-royce | \n", "0.260943 | \n", "0.412009 | \n", "0.080448 | \n", "0.037039 | \n", "0.072188 | \n", "0.321649 | \n", "4.843750 | \n", "4.508778 | \n", "
subaru | \n", "0.202121 | \n", "0.470115 | \n", "0.103731 | \n", "0.020184 | \n", "0.070802 | \n", "0.301044 | \n", "4.257212 | \n", "4.327014 | \n", "
suzuki | \n", "0.206990 | \n", "0.410432 | \n", "0.111564 | \n", "0.033440 | \n", "0.075242 | \n", "0.114764 | \n", "4.235119 | \n", "4.255248 | \n", "
tesla | \n", "0.296216 | \n", "0.379065 | \n", "0.064811 | \n", "0.024911 | \n", "0.066818 | \n", "0.154607 | \n", "4.673387 | \n", "4.284923 | \n", "
volvo | \n", "0.204267 | \n", "0.433600 | \n", "0.113805 | \n", "0.024111 | \n", "0.071134 | \n", "0.220652 | \n", "4.380814 | \n", "4.281185 | \n", "
\n", " | sentiment.score | \n", "emotion.sadness | \n", "emotion.joy | \n", "emotion.fear | \n", "emotion.disgust | \n", "emotion.anger | \n", "Rating\\r | \n", "Review_Content | \n", "Predicted_Y | \n", "
---|---|---|---|---|---|---|---|---|---|
Car_Make | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
AMGeneral | \n", "3 | \n", "3 | \n", "3 | \n", "3 | \n", "3 | \n", "3 | \n", "2 | \n", "3 | \n", "3 | \n", "
Acura | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "12 | \n", "42 | \n", "41 | \n", "
AlfaRomeo | \n", "16 | \n", "16 | \n", "16 | \n", "16 | \n", "16 | \n", "16 | \n", "4 | \n", "16 | \n", "16 | \n", "
AstonMartin | \n", "33 | \n", "33 | \n", "33 | \n", "33 | \n", "33 | \n", "33 | \n", "10 | \n", "33 | \n", "32 | \n", "
Audi | \n", "51 | \n", "51 | \n", "51 | \n", "51 | \n", "51 | \n", "51 | \n", "15 | \n", "51 | \n", "47 | \n", "
BMW | \n", "48 | \n", "48 | \n", "48 | \n", "48 | \n", "48 | \n", "48 | \n", "16 | \n", "48 | \n", "44 | \n", "
Bentley | \n", "36 | \n", "36 | \n", "36 | \n", "36 | \n", "36 | \n", "36 | \n", "14 | \n", "36 | \n", "32 | \n", "
Bugatti | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
Buick | \n", "53 | \n", "53 | \n", "53 | \n", "53 | \n", "53 | \n", "53 | \n", "19 | \n", "53 | \n", "51 | \n", "
Cadillac | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "15 | \n", "49 | \n", "47 | \n", "
Chevrolet | \n", "37 | \n", "37 | \n", "37 | \n", "37 | \n", "37 | \n", "37 | \n", "17 | \n", "37 | \n", "37 | \n", "
GMC | \n", "57 | \n", "57 | \n", "57 | \n", "57 | \n", "57 | \n", "57 | \n", "21 | \n", "57 | \n", "55 | \n", "
Honda | \n", "44 | \n", "44 | \n", "44 | \n", "44 | \n", "44 | \n", "44 | \n", "18 | \n", "44 | \n", "42 | \n", "
Toyota | \n", "46 | \n", "46 | \n", "46 | \n", "46 | \n", "46 | \n", "46 | \n", "11 | \n", "46 | \n", "43 | \n", "
Volkswagen | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "15 | \n", "40 | \n", "36 | \n", "
chrysler | \n", "46 | \n", "47 | \n", "47 | \n", "47 | \n", "47 | \n", "47 | \n", "19 | \n", "47 | \n", "47 | \n", "
dodge | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "16 | \n", "42 | \n", "39 | \n", "
ferrari | \n", "29 | \n", "29 | \n", "29 | \n", "29 | \n", "29 | \n", "29 | \n", "7 | \n", "29 | \n", "26 | \n", "
fiat | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "11 | \n", "49 | \n", "48 | \n", "
ford | \n", "53 | \n", "53 | \n", "53 | \n", "53 | \n", "53 | \n", "53 | \n", "18 | \n", "53 | \n", "52 | \n", "
genesis | \n", "23 | \n", "23 | \n", "23 | \n", "23 | \n", "23 | \n", "23 | \n", "3 | \n", "23 | \n", "22 | \n", "
hummer | \n", "38 | \n", "38 | \n", "38 | \n", "38 | \n", "38 | \n", "38 | \n", "15 | \n", "38 | \n", "38 | \n", "
hyundai | \n", "48 | \n", "48 | \n", "48 | \n", "48 | \n", "48 | \n", "48 | \n", "16 | \n", "48 | \n", "47 | \n", "
infiniti | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "13 | \n", "43 | \n", "41 | \n", "
isuzu | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "16 | \n", "42 | \n", "42 | \n", "
jaguar | \n", "55 | \n", "55 | \n", "55 | \n", "55 | \n", "55 | \n", "55 | \n", "13 | \n", "55 | \n", "48 | \n", "
jeep | \n", "61 | \n", "61 | \n", "61 | \n", "61 | \n", "61 | \n", "61 | \n", "20 | \n", "61 | \n", "60 | \n", "
kia | \n", "52 | \n", "52 | \n", "52 | \n", "52 | \n", "52 | \n", "52 | \n", "20 | \n", "52 | \n", "50 | \n", "
lamborghini | \n", "20 | \n", "20 | \n", "20 | \n", "20 | \n", "20 | \n", "20 | \n", "7 | \n", "20 | \n", "16 | \n", "
land-rover | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "21 | \n", "43 | \n", "43 | \n", "
lexus | \n", "48 | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "15 | \n", "49 | \n", "46 | \n", "
lincoln | \n", "39 | \n", "39 | \n", "39 | \n", "39 | \n", "39 | \n", "39 | \n", "16 | \n", "39 | \n", "36 | \n", "
lotus | \n", "21 | \n", "21 | \n", "21 | \n", "21 | \n", "21 | \n", "21 | \n", "9 | \n", "21 | \n", "21 | \n", "
maserati | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "13 | \n", "40 | \n", "38 | \n", "
maybach | \n", "3 | \n", "3 | \n", "3 | \n", "3 | \n", "3 | \n", "3 | \n", "2 | \n", "3 | \n", "3 | \n", "
mazda | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "14 | \n", "43 | \n", "42 | \n", "
mercedes-benz | \n", "47 | \n", "47 | \n", "47 | \n", "47 | \n", "47 | \n", "47 | \n", "19 | \n", "47 | \n", "45 | \n", "
mercury | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "49 | \n", "18 | \n", "49 | \n", "48 | \n", "
mini | \n", "38 | \n", "38 | \n", "38 | \n", "38 | \n", "38 | \n", "38 | \n", "15 | \n", "38 | \n", "33 | \n", "
mitsubishi | \n", "53 | \n", "53 | \n", "53 | \n", "53 | \n", "53 | \n", "53 | \n", "18 | \n", "53 | \n", "51 | \n", "
nissan | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "18 | \n", "43 | \n", "43 | \n", "
pontiac | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "14 | \n", "40 | \n", "39 | \n", "
porsche | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "40 | \n", "10 | \n", "40 | \n", "40 | \n", "
ram | \n", "34 | \n", "36 | \n", "36 | \n", "36 | \n", "36 | \n", "36 | \n", "10 | \n", "36 | \n", "36 | \n", "
rolls-royce | \n", "4 | \n", "4 | \n", "4 | \n", "4 | \n", "4 | \n", "4 | \n", "3 | \n", "4 | \n", "4 | \n", "
subaru | \n", "52 | \n", "52 | \n", "52 | \n", "52 | \n", "52 | \n", "52 | \n", "16 | \n", "52 | \n", "48 | \n", "
suzuki | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "42 | \n", "16 | \n", "42 | \n", "41 | \n", "
tesla | \n", "31 | \n", "31 | \n", "31 | \n", "31 | \n", "31 | \n", "31 | \n", "5 | \n", "31 | \n", "31 | \n", "
volvo | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "43 | \n", "15 | \n", "43 | \n", "42 | \n", "
\n", " | Rating\\r | \n", "Predicted_Y | \n", "
---|---|---|
\n", " | mean | \n", "mean | \n", "
Car_Make | \n", "\n", " | \n", " |
AMGeneral | \n", "4.833333 | \n", "4.264005 | \n", "
Acura | \n", "4.538690 | \n", "4.455716 | \n", "
AlfaRomeo | \n", "4.187500 | \n", "4.435494 | \n", "
AstonMartin | \n", "4.613636 | \n", "4.631018 | \n", "
Audi | \n", "4.453431 | \n", "4.421119 | \n", "
BMW | \n", "4.468750 | \n", "4.354955 | \n", "
Bentley | \n", "4.239583 | \n", "4.57587 | \n", "
Bugatti | \n", "4.750000 | \n", "4.718716 | \n", "
Buick | \n", "4.162736 | \n", "4.075432 | \n", "
Cadillac | \n", "4.395408 | \n", "4.335975 | \n", "
Chevrolet | \n", "4.104730 | \n", "4.23044 | \n", "
GMC | \n", "4.089912 | \n", "4.138499 | \n", "
Honda | \n", "3.832386 | \n", "4.130003 | \n", "
Toyota | \n", "4.350543 | \n", "4.243079 | \n", "
Volkswagen | \n", "4.396875 | \n", "4.17746 | \n", "
chrysler | \n", "4.140957 | \n", "4.168451 | \n", "
dodge | \n", "4.133929 | \n", "4.163826 | \n", "
ferrari | \n", "4.767241 | \n", "4.530158 | \n", "
fiat | \n", "3.818878 | \n", "4.134359 | \n", "
ford | \n", "4.040094 | \n", "4.005134 | \n", "
genesis | \n", "4.608696 | \n", "4.316763 | \n", "
hummer | \n", "4.404605 | \n", "4.462752 | \n", "
hyundai | \n", "4.109375 | \n", "4.14899 | \n", "
infiniti | \n", "4.566860 | \n", "4.393907 | \n", "
isuzu | \n", "4.220238 | \n", "4.306578 | \n", "
jaguar | \n", "4.584091 | \n", "4.497573 | \n", "
jeep | \n", "4.108607 | \n", "4.15378 | \n", "
kia | \n", "4.141827 | \n", "4.12064 | \n", "
lamborghini | \n", "4.725000 | \n", "4.665769 | \n", "
land-rover | \n", "3.848837 | \n", "4.0177 | \n", "
lexus | \n", "4.306122 | \n", "4.294433 | \n", "
lincoln | \n", "4.269231 | \n", "4.264042 | \n", "
lotus | \n", "4.702381 | \n", "4.490183 | \n", "
maserati | \n", "4.431250 | \n", "4.394369 | \n", "
maybach | \n", "4.958333 | \n", "4.733771 | \n", "
mazda | \n", "4.479651 | \n", "4.318612 | \n", "
mercedes-benz | \n", "4.095745 | \n", "4.094125 | \n", "
mercury | \n", "4.311224 | \n", "4.390451 | \n", "
mini | \n", "4.036184 | \n", "4.190949 | \n", "
mitsubishi | \n", "4.346698 | \n", "4.417798 | \n", "
nissan | \n", "4.247093 | \n", "4.119348 | \n", "
pontiac | \n", "4.375000 | \n", "4.221752 | \n", "
porsche | \n", "4.662500 | \n", "4.552274 | \n", "
ram | \n", "3.861111 | \n", "4.113366 | \n", "
rolls-royce | \n", "4.843750 | \n", "4.508778 | \n", "
subaru | \n", "4.257212 | \n", "4.327014 | \n", "
suzuki | \n", "4.235119 | \n", "4.255248 | \n", "
tesla | \n", "4.673387 | \n", "4.284923 | \n", "
volvo | \n", "4.380814 | \n", "4.281185 | \n", "