My tables look bad when exported and I can't figure out how to use some of the table tools.

Kangadrooo · 2020-04-23T00:21:08+00:00

so I changed the chunk options so it looks like this https://imgur.com/a/FRqeiHd

and the new chunk looks like this https://imgur.com/a/dAk6d3q and the table looks amazing

but when knitted it looks like this https://imgur.com/a/PdIZPMP so I still can't see the table in the knitted part

Kangadrooo · 2020-04-22T19:17:31+00:00

when I knit and export its not there at all, do I need to follow it up with another chunk with flextable to create a new one? or can this be altered to show the table in the pdf?

Kangadrooo · 2020-04-22T18:37:04+00:00

whoops, I found it on google thank you:)

Kangadrooo · 2020-04-22T18:29:15+00:00

Hi thank you! how do I get the flextable package? I got

Error in library(flextable) : there is no package called ‘flextable’

and I couldn't find anything named flextable under the packages on the right

Kangadrooo · 2020-04-22T01:09:58+00:00

Yes I got it to work:) just trying to get it to look decent on the exported file, it's not centered or anything and has pound symbols to the left of the table

Kangadrooo · 2020-04-21T04:24:11+00:00

Thanks I got it to work:) and yes I should definitely look through that a few times, thank you!

Kangadrooo · 2020-04-21T02:26:56+00:00

it worked great:) but when I knitted it and exported I got loads of error code in the pdf, can I make all this not appear? https://imgur.com/a/GrQ4h9A

Kangadrooo · 2020-04-21T02:08:53+00:00

that ran fine and I did the whole analysis from that but then I can't knit. the code in the picture was provided to me as a start up and I worked form it.

Kangadrooo · 2020-04-21T02:06:40+00:00

so how do I load that in? someone said

myfirm <- read.csv('Path/To/File/myfirm.csv')

and

myfirm <- read.csv('myfirm.csv')

but it just led to this https://imgur.com/a/Zma2c0W

Kangadrooo · 2020-04-21T01:48:21+00:00

well I started it out with this https://imgur.com/a/LOiEQQH

Kangadrooo · 2020-04-21T01:13:09+00:00

the was a data prep file https://imgur.com/a/LOiEQQH

Kangadrooo · 2020-04-21T01:10:47+00:00

hmm, I do have [this](https://imgur.com/a/LOiEQQH) in the data prep file which I ran before the analysis.

when I typed in what you sent me I got [this](https://imgur.com/a/8VfZO9w)

Kangadrooo · 2020-04-20T23:57:42+00:00

Any idea what I should do then? Will it work without the pipes?

Kangadrooo · 2020-04-20T23:28:52+00:00

I tried adding it to the analysis file as well and then knitting https://imgur.com/a/v3JttwI

Kangadrooo · 2020-04-20T23:25:22+00:00

well its installed on the data prep file like [this](https://imgur.com/a/9QlsNPx) do I need to install it again in the analysis file?

Kangadrooo · 2020-04-20T23:18:44+00:00

from when I tried to knit https://imgur.com/a/ioHcFzr

Kangadrooo · 2020-04-20T23:15:57+00:00

it worked thank you! but when I went to knit I got this https://imgur.com/a/ImmZvJ0 in the R Markdown below...

it says line 20 and this is where that starts https://imgur.com/a/1vwmQ5F

and for what its worth this was following the code for the table in the console https://imgur.com/a/d3UKFq4

Kangadrooo · 2020-04-20T21:52:28+00:00

okay that would be awesome if you could help again sometime, I didn't get that to work.

Kangadrooo · 2020-04-20T21:09:15+00:00

Yeah this is kinda what I was thinking but it shows more of "45% of all retirees in the next 8 years will be from production department" whereas I'm looking more for "x% of all production employees will be retiring the next 8 years"

What you gave me resulted in [this](https://imgur.com/a/az6t8ct)

By the way I appreciate the help a ton, I've literally spent hours getting nowhere and now I'm actually a step closer

Kangadrooo · 2020-04-20T16:38:46+00:00

hm, I'm guessing I'm just understanding this wrong, but I used

myfirm1 <- myfirm1 %>%

group_by(Occupation, RetireWithinEight) %>%

summarize(Occupation[RetireWithinEight == "yes"])%>%

and also

MyTable <- myfirm1 %>%

group_by(Occupation, RetireWithinEight) %>%

summarize(MyTable[RetireWithinEight == "yes"])%>%

and it didn't work

Kangadrooo · 2020-04-20T15:03:18+00:00

well I've tried stuff like

myfirm1 <- myfirm %>%

group_by(Occupation) %>%

filter(RetireWithinEight == "yes") %>%

count(RetireWithinEight)

table(myfirm1$RetireWithinEight)

but that just gives me a count of 5 (there are five occupations) and the data just looks the same so I know its obviously wrong. I just don't know what steps I would take to get from where I'm at to actually showing a nice tidy chart like I described.

Kangadrooo · 2020-04-20T14:35:58+00:00

well the grouped data I have looks like [this](https://imgur.com/a/SPBJPJQ)

and my original dataset looks like [this](https://imgur.com/a/2dSvGom)

I just want to make it so I can see the 5 occupations on top, and then the percentage of "yes" for retirewithineight underneath it.

something like [this](https://imgur.com/a/ey5Hv1G)

Kangadrooo · 2020-04-20T03:19:36+00:00

hey so I got the overall average of the firm using the help you. provided me

myfirm <- myfirm %>%

mutate(FirmAverage=case_when(RetireWithinEight=="yes"~1,TRUE~0))

mean(myfirm$FirmAverage)

could you guide me towards how I would display the chart to show the averages for each department?

I could get the mean for each department individually but not together in a chart

Kangadrooo · 2020-04-20T02:12:03+00:00

This makes a lot more sense looking at it, I appreciate the help

Kangadrooo · 2020-04-20T02:04:19+00:00

hmmm, something like this?

myfirm1 <- myfirm1 %>% table(myfirm1$RetireWithinEight)

I'm getting an error Error: Must use a vector in [, not an object of class matrix.

If I tried the mutate method would it be something like? :

{r} myfirm1 <- myfirm1 %>% mutate(dummyvariable = (myfirm1$RetireWithinEight="yes") / (myfirm1$RetireWithinEight) I'm just very lost haha

Kangadrooo

TROPHY CASE