Home › Forums › Analytics / Predictive Analytics › how do i copy and paste a table In R for exam PA???
- This topic has 7 replies, 8 voices, and was last updated 9 months, 2 weeks ago by
richerd bond.
-
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.
April 28, 2024 at 3:35 pm #25074simply control c + control v
June 2, 2024 at 6:55 am #25156To copy and paste a table in R for the PA exam, first create the table using functions like data.frame to structure your data. Once your table is ready, display it in the R console by either using the print() function or simply typing the table’s name. Highlight the displayed table in the console and copy it by pressing Ctrl+C on Windows or Cmd+C on Mac. Next, open your desired document, such as a Word or Excel file, or the exam interface, and paste the table by pressing Ctrl+V on Windows or Cmd+V on Mac. This process ensures that the table’s format is retained, making it clear and readable in the pasted location.
-
AuthorPosts
- You must be logged in to reply to this topic.