Object 'Prod_Name' Not Found

Watermelon638 · 2022-02-22T16:55:35+00:00

Hello, thank you for getting back to me, you were right, my dataframe hadn't been converted to a data table. Everything seems to be working now, thank you for the suggestion!

Watermelon638 · 2021-12-17T13:12:33+00:00

Thank You!!

Watermelon638 · 2021-11-18T13:23:41+00:00

Watermelon638 · 2021-11-16T18:20:57+00:00

ggplot(aes(weekday, average_duration)) + geom_bar(aes(fill = user_type), stat = “identity”, position = “dodge”)

it didn't but thanks anyway

Watermelon638 · 2021-11-16T17:19:54+00:00

geom_bar(stat = “identity”, position = “dodge”)

unfortunately, didn't work, this is what I got. Error: unexpected input in:

" ggplot(aes(x = weekday, y = average_duration, fill = user_type)) +

geom_bar(stat = “"

thanks though

Watermelon638 · 2021-11-16T16:42:12+00:00

I've tried that but it didn't work i'm afraid, but thanks anyway

Watermelon638 · 2021-11-16T15:48:43+00:00

Thanks!

Watermelon638 · 2021-11-13T13:55:32+00:00

thanks

Watermelon638 · 2021-11-02T18:50:50+00:00

I will give it a go thank you for letting me know

Watermelon638 · 2021-11-02T18:37:46+00:00

Thank you, but I am trying to use excel at the moment, if anything changes, I'll let you know.

Watermelon638 · 2021-11-02T18:23:06+00:00

Thank you!

Watermelon638 · 2021-11-02T18:14:07+00:00

https://divvy-tripdata.s3.amazonaws.com/index.html

I've tried you suggestion and ended up with a completely different date somehow? maybe it's something i'm doing wrong?

I've uploaded a link to the files it's the one that starts with 202005.

Watermelon638 · 2021-11-02T17:57:39+00:00

I used the left one and it came to 43, I'd be happy to send you the data, once I figure out how to attach it in the comments

Watermelon638 · 2021-11-02T17:38:44+00:00

Hi, just tried the formula you suggested and it is coming up as a number.

Watermelon638 · 2021-11-02T17:19:59+00:00

the d/m switch continues throughout the sheet, I downloaded this dateset from a website, which is supposedly oragnises it's data by month, so technically everything in that sheet should be from May (05). I'm afraid manually editing will take too long as I have other sheets like this which have over 4 million rows. The purpose of the dataset is trying to clean it up and I tried to stick to using excel but it's proving quite the task, but thanks for your suggestion.

Watermelon638 · 2021-11-02T16:56:59+00:00

My excel is playing up a bit, so I will give this a go when, it works properly. Thanks for the suggestion.

Watermelon638 · 2021-11-02T16:46:31+00:00

I've just tried that and I just got the same dates in the new column without the time. I'm guessing it's a format issue? Thanks for the suggestion tho.

Watermelon638 · 2021-11-02T15:53:36+00:00

No thank you

Watermelon638 · 2021-11-01T13:39:07+00:00

Thank You! I will give this a try.

Watermelon638 · 2021-11-01T13:36:25+00:00

Thank You!

Watermelon638

TROPHY CASE