[R] I had 1 problem with r
Jim Lemon
drjimlemon at gmail.com
Mon Aug 22 10:15:53 CEST 2016
Hi SuBin,
This seems to work:
emp<-read.table(text="empno,ename,job,mgr,hiredate,sal,comm,deptno
7369,SMITH,CLERK,7902,1980-12-17,800,,20
7499,ALLEN,SALESMAN,7698,1981-02-20,1600,300,30
7521,WARD,SALESMAN,7698,1981-02-03,1250,500,30
7566,JONES,MANAGER,7839,1981-03-02,2975,,20
7654,MARTIN,SALESMAN,7698,1981-10-22,1250,1400,30
7698,BLAKE,MANAGER,7839,1981-05-01,2850,,30
7782,CLARK,MANAGER,7839,1981-09-06,2450,,10
7788,SCOTT,ANALYST,7566,1982-12-08,3000,,20
7839,KING,PRESIDENT,,1981-11-17,5000,,10
7844,TURNER,SALESMAN,7698,1984-10-08,1500,,30
7876,ADAMS,CLERK,7788,1983-01-12,1100,,20
7900,JAMES,CLERK,7698,1981-12-03,950,,30
7902,FORD,ANALYST,7566,1981-12-13,3000,,20
7934,MILLER,CLERK,7782,1982-01-25,1300,,10",
header=TRUE,sep=",")
emp[grep("^A",emp$ename),c("ename","sal")]
ename sal
2 ALLEN 1600
11 ADAMS 1100
Jim
On Mon, Aug 22, 2016 at 3:06 PM, 정수빈 <subincj at naver.com> wrote:
> Hi My name is SuBin-Jung from Korea.
>
> I can't write english well. so, understand me please.
>
> I used R Gui(64-bit) program.
>
> And in program, I imported this csv file named "emp.csv"
>
> emp.csv
> ---------------------------------------------
> empno,ename,job,mgr,hiredate,sal,comm,deptno
> 7369,SMITH,CLERK,7902,1980-12-17,800,,20
> 7499,ALLEN,SALESMAN,7698,1981-02-20,1600,300,30
> 7521,WARD,SALESMAN,7698,1981-02-03,1250,500,30
> 7566,JONES,MANAGER,7839,1981-03-02,2975,,20
> 7654,MARTIN,SALESMAN,7698,1981-10-22,1250,1400,30
> 7698,BLAKE,MANAGER,7839,1981-05-01,2850,,30
> 7782,CLARK,MANAGER,7839,1981-09-06,2450,,10
> 7788,SCOTT,ANALYST,7566,1982-12-08,3000,,20
> 7839,KING,PRESIDENT,,1981-11-17,5000,,10
> 7844,TURNER,SALESMAN,7698,1984-10-08,1500,,30
> 7876,ADAMS,CLERK,7788,1983-01-12,1100,,20
> 7900,JAMES,CLERK,7698,1981-12-03,950,,30
> 7902,FORD,ANALYST,7566,1981-12-13,3000,,20
> 7934,MILLER,CLERK,7782,1982-01-25,1300,,10
> ----------------------------------------------
>
> Then I used command "read.csv" ==> read.csv("emp.csv")
>
> And I tried to find emp$ename with first alphabet 'A'.
>
> So I inserted this command on program :
>
> > subset(emp, ename==grep("^A+",ename,value=TRUE), select=c("ename","sal"))
>
> But the result is not found.
>
> After that I tried to other alphabets( B,S,W....)
>
> > subset(emp, ename==grep("^S+",ename,value=TRUE), select=c("ename","sal"))
>
> Then I can find two data.
>
> ename sal
> 1 SMITH 800
> 8 SCOTT 3000
>
>
> Why can't I find emp$ename with first alphavet 'A'??
> I think this is error.
> Please give me answer, sir.
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
More information about the R-help
mailing list