Hello, how are you? I am a beginner in Rstudio and I have a question about a problem that I can't solve.
Exercise: White and grey cars are the fastest selling cars, what do you think of this statement?
The problem is that the sales time is being given to me in days, hours and minutes, so when I try to make a boxplot and organize it does not take it as it should be, also in the data I get the time type 2 hours, 34 minutes, as I will show you next
The database is in Spanish
I tried with the formula of table(Carros$Tiempo, Carros$Color) but I get something very general and messy so to speak as I will show you
beige black blue brown charcoal gold gray green no_color
1 día 0 4 0 0 0 0 3 0 0
1 hora 0 1 0 0 0 0 0 0 0
10 días 0 0 0 0 0 0 0 0 0
12 horas 0 0 0 0 0 0 0 0 0
14 horas 0 3 1 0 0 0 2 0 0
16 horas 0 1 0 0 0 0 2 0 0
17 horas 0 7 2 0 0 0 4 1 1
19 horas 0 0 0 0 0 0 1 0 0
2 días 0 31 3 0 5 2 16 3 1
20 horas 1 3 0 0 0 0 1 0 0
21 hora 0 14 1 0 0 0 13 1 4
22 horas 0 3 2 1 0 0 9 0 0
23 horas 0 0 1 0 0 0 1 0 0
3 días 0 11 4 0 0 0 10 1 0
32 Minutos 0 0 0 0 0 0 0 0 0
34 Minutos 0 0 0 0 0 0 1 0 0
36 Minutos 0 0 0 0 0 0 0 0 0
4 días 0 1 0 0 0 0 3 0 0
5 horas 0 0 0 0 0 0 1 0 0
6 días 0 4 0 0 0 0 4 0 0
7 días 0 0 0 0 0 0 1 0 0
8 días 0 0 2 0 0 0 2 0 0
Listing Expired 0 0 1 0 0 0 0 0 0
off-white orange red silver white
1 día 0 0 0 1 6
1 hora 0 0 0 0 0
10 días 0 1 1 0 5
12 horas 0 0 0 0 1
14 horas 0 0 3 4 5
16 horas 0 0 1 0 3
17 horas 0 0 0 3 2
19 horas 0 0 0 0 1
2 días 0 2 8 23 41
20 horas 0 0 1 1 1
21 hora 0 0 8 7 13
22 horas 0 0 5 1 3
23 horas 0 0 0 0 0
3 días 1 0 5 5 11
32 Minutos 0 0 0 1 0
34 Minutos 0 0 0 0 0
36 Minutos 0 0 1 0 0
4 días 0 0 0 1 0
5 horas 0 0 0 0 1
6 días 0 1 0 0 3
7 días 0 0 0 0 0
8 días 0 0 0 2 4
Listing Expired 0 0 1 0 2
So the question is: is there a way to move that time in days, hours and minutes to just minutes?, is there a way to make a boxplot, a bar chart where it can be better appreciated and thus be able to answer the initial question? Thanks for everything and I hope you have a nice day.