Re: [R] Remove all factor levels from an R dataframe
Hi John, df1<-sapply(df1,as.character) Should do what you ask. The error message probably means that you should do this: df1<-df1[order(as.character(df1$year)),] as "year" is the name of the first column in df1, not a separate object. Jim On Tue, Nov 10, 2020 at 6:57 PM John wrote: > Hi, > >I would like to sort the following simple dataframe by "year" > (characters), but the factor structure prevents me from doing so. How can I > remove the factor structure? Thanks! > > > df1 > year country > 4 2007 Asia; survey > 5 2010 8 countries in E/SE Asia > 6 2015Ghana > 7 > 8 2000 US? > > str(df1) > 'data.frame': 5 obs. of 2 variables: > $ year : Factor w/ 9 levels "2017","2016",..: 4 5 3 6 7 > $ country: Factor w/ 9 levels "Euro Area\\newline Testing the MP > performance of the Euro Area",..: 4 5 6 7 8 > > df1[order(-year), ] > Error in order(-year) : object 'year' not found > > [[alternative HTML version deleted]] > > __ > R-help@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]] __ R-help@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.
Re: [R] Remove all factor levels from an R dataframe
Thanks Jim. Can we do descending order? Jim Lemon 於 2020年11月10日 週二 下午4:56寫道： > Hi John, > > df1<-sapply(df1,as.character) > > Should do what you ask. The error message probably means that you should > do this: > > df1<-df1[order(as.character(df1$year)),] > > as "year" is the name of the first column in df1, not a separate object. > > Jim > > On Tue, Nov 10, 2020 at 6:57 PM John wrote: > >> Hi, >> >>I would like to sort the following simple dataframe by "year" >> (characters), but the factor structure prevents me from doing so. How can >> I >> remove the factor structure? Thanks! >> >> > df1 >> year country >> 4 2007 Asia; survey >> 5 2010 8 countries in E/SE Asia >> 6 2015Ghana >> 7 >> 8 2000 US? >> > str(df1) >> 'data.frame': 5 obs. of 2 variables: >> $ year : Factor w/ 9 levels "2017","2016",..: 4 5 3 6 7 >> $ country: Factor w/ 9 levels "Euro Area\\newline Testing the MP >> performance of the Euro Area",..: 4 5 6 7 8 >> > df1[order(-year), ] >> Error in order(-year) : object 'year' not found >> >> [[alternative HTML version deleted]] >> >> __ >> R-help@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]] __ R-help@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.
Re: [R] Remove all factor levels from an R dataframe
Sure John, df1<-df1[order(as.character(df1$year),decreasing=TRUE),] Jim On Tue, Nov 10, 2020 at 8:05 PM John wrote: > Thanks Jim. Can we do descending order? > > Jim Lemon 於 2020年11月10日 週二 下午4:56寫道： > >> Hi John, >> >> df1<-sapply(df1,as.character) >> >> Should do what you ask. The error message probably means that you should >> do this: >> >> df1<-df1[order(as.character(df1$year)),] >> >> as "year" is the name of the first column in df1, not a separate object. >> >> Jim >> >> On Tue, Nov 10, 2020 at 6:57 PM John wrote: >> >>> Hi, >>> >>>I would like to sort the following simple dataframe by "year" >>> (characters), but the factor structure prevents me from doing so. How >>> can I >>> remove the factor structure? Thanks! >>> >>> > df1 >>> year country >>> 4 2007 Asia; survey >>> 5 2010 8 countries in E/SE Asia >>> 6 2015Ghana >>> 7 >>> 8 2000 US? >>> > str(df1) >>> 'data.frame': 5 obs. of 2 variables: >>> $ year : Factor w/ 9 levels "2017","2016",..: 4 5 3 6 7 >>> $ country: Factor w/ 9 levels "Euro Area\\newline Testing the MP >>> performance of the Euro Area",..: 4 5 6 7 8 >>> > df1[order(-year), ] >>> Error in order(-year) : object 'year' not found >>> >>> [[alternative HTML version deleted]] >>> >>> __ >>> R-help@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]] __ R-help@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.
Re: [R] Remove all factor levels from an R dataframe
Hi John, I was thinking that you created df1 in a way that set the 'year' column as a factor when this is not what you wanted to do. The data.frame() function takes an argument stringsAsFactors which controls this behavior. For R versions 3.6.3 or earlier, the default setting is stringsAsFactors=TRUE, which means that string columns automatically become factors. You have to specify stringsAsFactors=FALSE to avoid this. (In R 4.0.x the default was changed to FALSE.) Example: df1 <- data.frame( a=letters[1:10], stringsAsFactors=FALSE ) HTH, Eric On Tue, Nov 10, 2020 at 11:16 AM Jim Lemon wrote: > > Sure John, > > df1<-df1[order(as.character(df1$year),decreasing=TRUE),] > > Jim > > On Tue, Nov 10, 2020 at 8:05 PM John wrote: > > > Thanks Jim. Can we do descending order? > > > > Jim Lemon 於 2020年11月10日 週二 下午4:56寫道： > > > >> Hi John, > >> > >> df1<-sapply(df1,as.character) > >> > >> Should do what you ask. The error message probably means that you should > >> do this: > >> > >> df1<-df1[order(as.character(df1$year)),] > >> > >> as "year" is the name of the first column in df1, not a separate object. > >> > >> Jim > >> > >> On Tue, Nov 10, 2020 at 6:57 PM John wrote: > >> > >>> Hi, > >>> > >>>I would like to sort the following simple dataframe by "year" > >>> (characters), but the factor structure prevents me from doing so. How > >>> can I > >>> remove the factor structure? Thanks! > >>> > >>> > df1 > >>> year country > >>> 4 2007 Asia; survey > >>> 5 2010 8 countries in E/SE Asia > >>> 6 2015Ghana > >>> 7 > >>> 8 2000 US? > >>> > str(df1) > >>> 'data.frame': 5 obs. of 2 variables: > >>> $ year : Factor w/ 9 levels "2017","2016",..: 4 5 3 6 7 > >>> $ country: Factor w/ 9 levels "Euro Area\\newline Testing the MP > >>> performance of the Euro Area",..: 4 5 6 7 8 > >>> > df1[order(-year), ] > >>> Error in order(-year) : object 'year' not found > >>> > >>> [[alternative HTML version deleted]] > >>> > >>> __ > >>> R-help@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]] > > __ > R-help@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. __ R-help@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.
[R] R ioanalysis pkg
Hi, Hope you are doing well, I´m trying to start working with ioanalysis package, however its being difficult for me to prepare data from my own input-output table, import it into R in order to apply the ioanalysis functions Any help on this will be highly appreciated. Please note that I do not need links to the ioanalysis manual nor to pages describing the package and its functions, but something like a tutorial or worked example on how to prepare data from the input-output table import data into R, so that after that i can work with ioanalysis Thank you very much in advance Gaspar Núñez [[alternative HTML version deleted]] __ R-help@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.
Re: [R] R ioanalysis pkg
There are around 20,000 specialized packages for R. This list is set up to
help on standard R features and packages, but cannot possibly be expected
to support 20,000 packages. As the posting guide says (did you read it??!):
"If the question relates to a *contributed package* , e.g., one downloaded
from CRAN, try contacting the package maintainer first. You can also use
find("functionname") and packageDescription("packagename") to find this
information. *Only* send such questions to R-help or R-devel if you get no
reply or need further assistance. This applies to both requests for help
and to bug reports."
(Note also: ?maintainer)
So did you you do this?
Bert Gunter
"The trouble with having an open mind is that people keep coming along and
sticking things into it."
-- Opus (aka Berkeley Breathed in his "Bloom County" comic strip )
On Tue, Nov 10, 2020 at 4:55 PM Gaspar Núñez wrote:
> Hi,
>
> Hope you are doing well, I´m trying to start working
> with ioanalysis package, however its being difficult for me
> to prepare data from my own input-output table,
> import it into R in order to apply the ioanalysis functions
> Any help on this will be highly appreciated.
> Please note that I do not need links to the ioanalysis manual
> nor to pages describing the package and its functions,
> but something like a tutorial or worked example on
> how to prepare data from the input-output table
> import data into R, so that after that i can work with ioanalysis
>
> Thank you very much in advance
>
> Gaspar Núñez
>
> [[alternative HTML version deleted]]
>
> __
> R-help@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]]
__
R-help@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.
Re: [R] R ioanalysis pkg
On 11/10/20 5:08 PM, Bert Gunter wrote:
There are around 20,000 specialized packages for R. This list is set up to
help on standard R features and packages, but cannot possibly be expected
to support 20,000 packages. As the posting guide says (did you read it??!):
"If the question relates to a *contributed package* , e.g., one downloaded
from CRAN, try contacting the package maintainer first. You can also use
find("functionname") and packageDescription("packagename") to find this
information. *Only* send such questions to R-help or R-devel if you get no
reply or need further assistance. This applies to both requests for help
and to bug reports."
(Note also: ?maintainer)
So did you you do this?
Bert Gunter
To follow up on this ... the StackOverflow forum also handles coding
questions but it specifically advises against posting overly broad
questions or requests for package recommendations or other requests for
external sources of programming advice or tutoring.
Like Rhelp, SO advises questioners is to prepare a test dataset and to show
what efforts have been made using R code. The code should preferably install
the package and then load it. It should then make whatever preliminary
transformations you have attempted along with the compete error messages or
descriptions of what results failed to meet your expectations.
Neither Rhelp or SO should be considered as sources for one-off tutorials or as
places to ask for one-off projects builds.
--
David.
On Tue, Nov 10, 2020 at 4:55 PM Gaspar Núñez wrote:
Hi,
Hope you are doing well, I´m trying to start working
with ioanalysis package, however its being difficult for me
to prepare data from my own input-output table,
import it into R in order to apply the ioanalysis functions
Any help on this will be highly appreciated.
Please note that I do not need links to the ioanalysis manual
nor to pages describing the package and its functions,
but something like a tutorial or worked example on
how to prepare data from the input-output table
import data into R, so that after that i can work with ioanalysis
Thank you very much in advance
Gaspar Núñez
[[alternative HTML version deleted]
And Rhelp does not accept HTML code. If you had included code, it
would probably have been mangles. Use plain text.
__
R-help@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.
Re: [R] R ioanalysis pkg
Hi Gaspar, I can see why you are having trouble with this. The "as.inputoutput" function seems to be the core. While the manual claims you can just input the "Z", "RS_label" and and "X" matrices to "as.inputoutput" and get the "InputOutput" object that you need for all the other functions, it looks to me as though the required input matrices are not trivial to create. The manual is confusing as the argument name "Z" is overprinted by "RS_label" My guess is that you will have to know a bit about what you are doing to use the package. Jim On Wed, Nov 11, 2020 at 11:55 AM Gaspar Núñez wrote: > Hi, > > Hope you are doing well, I´m trying to start working > with ioanalysis package, however its being difficult for me > to prepare data from my own input-output table, > import it into R in order to apply the ioanalysis functions > Any help on this will be highly appreciated. > Please note that I do not need links to the ioanalysis manual > nor to pages describing the package and its functions, > but something like a tutorial or worked example on > how to prepare data from the input-output table > import data into R, so that after that i can work with ioanalysis > > Thank you very much in advance > > Gaspar Núñez > > [[alternative HTML version deleted]] > > __ > R-help@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]] __ R-help@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.
