Home › Forums › Analytics / Predictive Analytics › how do i copy and paste a table In R for exam PA???
- This topic has 5 replies, 6 voices, and was last updated 1 month, 1 week ago by
Emavo Livia.
-
AuthorPosts
-
February 8, 2021 at 6:58 pm #3158
In the SOA solution for the December 2019 exam they have a table that makes it clear that we should combine a variable. It looks like this
Martial_status…………target=low value…………target=high value…………n…………proportion of high value
divorced……………………5829………………………………669……………………6498…………0.10295476
Married-AF_spouse……19…………………………………..12……………………31……………….0.38709677
etc. etc. note I can not copy paste a table here either so it also does not look good, but in the actual solution it is very clear.
This table makes it VERY quick and easy to see what needs to be combined. It would take two seconds using a pivot table in excel but we can not use that feature.
I like doing:
table(df$marital_status,df$value_flag)
which gives me the perfect summary. However I can not easily copy and paste this from R to excel.
Rather than write some confusing (and easily forgotten) code in R to make this table, how do we get this table into our word document???
Is there some easy way to copy from R to excel? Is this a simple function not contained in the solution?
February 9, 2021 at 8:35 pm #3171Best regards,
Sam Castillo
Course Instructor at ExamPA.net
May 30, 2021 at 12:40 pm #4803simply control c + control v, after you paste the table into word, select the whole table and go to ‘layout’ tab, use Autofit – Autofit to contents or Autofit to window
pls correct me if this doesnt work.
August 17, 2023 at 9:53 pm #24416Hi, friend. Personally, I used for the exam turbo vector images for a better visual perception. This gave me some dividends and I got results. It seems to me that this is a rather creative approach and it allows you to stand out and attract attention. I advise you to try to do as I do.</p>
September 8, 2023 at 9:28 pm #24452Hey there! In my personal experience, I found that using turbo vector images for my exams significantly improved my visual understanding and helped me achieve better results. I believe it’s a unique and creative strategy that can make you stand out and capture attention. I’d recommend giving it a try and see if it works for you as well. read more mod lone ly
October 23, 2023 at 8:19 pm #24564You can simply use the copy (Ctrl+C) and paste (Ctrl+V) commands. After pasting the table into Word, select the entire table and navigate to the ‘Layout’ tab, where you can utilize the ‘Autofit’ option, choosing either ‘Autofit to Contents’ or ‘Autofit to Window.’
Feel free to correct me if this method doesn’t yield the desired results.
-
AuthorPosts
- You must be logged in to reply to this topic.