I'm sorry if this is well below the level of this forum. Using R Console v3.1.3 32-bit Both of our R Programming sources left the company and I'm in need of some very basic help. The code is reading in column and row information from two xlsx files. I made what I thought were some basic changes to the contents of those files, one was a correction to a typo for a row, the other was flipping two columns that were in the wrong order. When I Source the R Code neither change shows up in the output. Thank you for your time. Cordially, Bob Lyons ________________________________ IMPORTANT NOTICE REGARDING THIS MESSAGE: This message is intended for the use of the person(s) and/or entity(s) to whom it is addressed and may contain information that is privileged, confidential, and protected from disclosure under applicable law. If you are not the intended recipient, your use of this message for any purpose is strictly prohibited. If you have received this communication in error, please delete the message and notify the sender immediately. [[alternative HTML version deleted]]
Did you start in a clean R session? What is your code? We can't telepathically diagnose code that's not sent to the list. Why not just change the data frames in R? Please read the posting guide linked at the bottom of this message, and provide enough information that we can reasonably help you. Basic questions are fine, but we expect the querent to have done a bit of work on their own, and to provide complete explanations. Sarah On Tue, Mar 24, 2015 at 8:40 AM, Robert Lyons <RLyons at m2s.com> wrote:> I'm sorry if this is well below the level of this forum. > Using R Console v3.1.3 32-bit > Both of our R Programming sources left the company and I'm in need of some very basic help. > The code is reading in column and row information from two xlsx files. > I made what I thought were some basic changes to the contents of those files, one was a correction to a typo for a row, the other was flipping two columns that were in the wrong order. > When I Source the R Code neither change shows up in the output. > > Thank you for your time. > > Cordially, > Bob Lyons > > > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.-- Sarah Goslee\ http://www.functionaldiversity.org
On Tue, Mar 24, 2015 at 7:40 AM, Robert Lyons <RLyons at m2s.com> wrote:> I'm sorry if this is well below the level of this forum. > Using R Console v3.1.3 32-bit > Both of our R Programming sources left the company and I'm in need of some very basic help. > The code is reading in column and row information from two xlsx files. > I made what I thought were some basic changes to the contents of those files, one was a correction to a typo for a row, the other was flipping two columns that were in the wrong order. > When I Source the R Code neither change shows up in the output.Well, first of all, nobody can help you with code unless you actually post the code in question. Hard to fix the car while you're driving it. [grin] Second, if you do post some code, you __REALLY__ need to disable posting in HTML. HTML messages normally come across on this forum as junk and most won't even try to read them. I may be off base on the following and likely be corrected if I am. But, unless the "fix" is simple, which from your post seems likely, you might be better off hiring a contractor who is an R programmer. Especially, as it appears in the case, that this is a for-profit company. TANSTAAFL, although many will help if they are curious and have time.> > Thank you for your time. > > Cordially, > Bob Lyons >-- If you sent twitter messages while exploring, are you on a textpedition? He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown
Hi Bob, Most likely you didn't save the resulting Excel file before sourcing the R code. I would close Excel (which given the time elapsed since your message you probably have done) and open the XSLX file again. If the changes are there in Excel, they should show up when you run the R code (using the xlsx package, we assume?) Although Sarah's answer may be more sensible. Jim On Wed, Mar 25, 2015 at 5:00 AM, John McKown <john.archie.mckown at gmail.com> wrote:> On Tue, Mar 24, 2015 at 7:40 AM, Robert Lyons <RLyons at m2s.com> wrote: > > I'm sorry if this is well below the level of this forum. > > Using R Console v3.1.3 32-bit > > Both of our R Programming sources left the company and I'm in need of > some very basic help. > > The code is reading in column and row information from two xlsx files. > > I made what I thought were some basic changes to the contents of those > files, one was a correction to a typo for a row, the other was flipping two > columns that were in the wrong order. > > When I Source the R Code neither change shows up in the output. > > Well, first of all, nobody can help you with code unless you actually > post the code in question. Hard to fix the car while you're driving > it. [grin] > > Second, if you do post some code, you __REALLY__ need to disable > posting in HTML. HTML messages normally come across on this forum as > junk and most won't even try to read them. > > I may be off base on the following and likely be corrected if I am. > But, unless the "fix" is simple, which from your post seems likely, > you might be better off hiring a contractor who is an R programmer. > Especially, as it appears in the case, that this is a for-profit > company. TANSTAAFL, although many will help if they are curious and > have time. > > > > > Thank you for your time. > > > > Cordially, > > Bob Lyons > > > > > > -- > If you sent twitter messages while exploring, are you on a textpedition? > > He's about as useful as a wax frying pan. > > 10 to the 12th power microphones = 1 Megaphone > > Maranatha! <>< > John McKown > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]