
hello everyone , I have a .csv file with specific data inside .
for ex.:
| Vehicle Name |
Sports Car |
SUV |
Wagon |
Minivan |
Pickup |
AWD |
RWD |
Retail Price |
Dealer Cost |
Engine Size (l) |
Cyl |
HP |
City MPG |
Hwy MPG |
| Acura 3.5 RL 4dr |
1 | 0 |
0 |
0 |
0 |
0 |
0 |
43755 |
39014 |
3.5 |
6 |
225 |
18 |
24 |
| Acura 3.5 RL w/Navigation 4dr |
0 |
1 | 0 |
0 |
0 |
0 |
0 |
46100 |
41100 |
3.5 |
6 |
225 |
18 |
24 |
SO on ...
I need to plot a scattered chart with X being HP and Y being Hwy MPG. I want to show the HP and MPG values for Vehicle that has the value 1 in the SUV or Sports Car columns.
this final graph show look like the picture above.
ANY ONE CAN HELP ME ???