[R] Help understanding loop behaviour

2021-04-29 Thread e-mail ma015k3113 via R-help
I am trying to understand how loops in operate. I have a simple dataframe xx which is as follows COMPANY_NUMBER NUMBER_OF_YEARS #0070837 3 #0070837 3 #0070837 3 1000403 4 1000403

Re: [R] Looping through data error

2021-04-13 Thread e-mail ma015k3113 via R-help
_OF_SHARES[i] = 100/is.na(CLOSE_SHARE_PRICE[i]) >} > } > > > Hope this helps, > > Rui Barradas > > Às 13:51 de 13/04/21, e-mail ma015k3113 via R-help escreveu: > > Dear All,I have a dataframe with 4 variables and I am trying to calculate > > how many shares can be purchased

Re: [R] Looping through data error

2021-04-13 Thread e-mail ma015k3113 via R-help
> > > Jim Holtman > Data Munger Guru > > What is the problem that you are trying to solve? > Tell me what you want to do, not how you want to do it. > > > On Tue, Apr 13, 2021 at 5:51 AM e-mail ma015k3113 via R-help < >

[R] Looping through data error

2021-04-13 Thread e-mail ma015k3113 via R-help
Dear All,I have a dataframe with 4 variables and I am trying to calculate how many shares can be purchased with £100 in the first year when the company was listed The data looks like: COMPANY_NUMBER YEAR_END_DATE CLOSE_SHARE_PRICE NUMBER_OF_SHARES 2270530/09/200

Re: [R] [EXT] Calculating the total change in shareprice over a time periond

2021-04-01 Thread e-mail ma015k3113 via R-help
    22705 CARDIFF PROPERTY PUBLIC LIMITED COMPANY (THE)Egham    > 30/09/2007  9.65  NA > 4  22705 CARDIFF PROPERTY PUBLIC LIMITED COMPANY (THE)Egham    > 30/09/2008  6.55   -3.10 > > Good luck. > > David Stevens > > On 3/31/202

[R] Calculating the total change in shareprice over a time periond

2021-03-31 Thread e-mail ma015k3113 via R-help
Dear All, I have a data frame which is structured as follows: COMPANY_NUMBER COMPANY_NAMECITYYEAR_END_DATE CLOSE_SHARE_PRICE 22705 CARDIFF PROPERTY PUBLIC LIMITED COMPANY (THE)Egham 30/09/2005 NA 22705 CARDIFF PROPERTY PUBLIC LIMITED COMPANY (THE)Egham

[R] Converting POSIXct format date to Character format

2021-03-24 Thread e-mail ma015k3113 via R-help
I have a data frame "PLC" which has two variables Year_END_Date EPS YEAR_END_Date EPS 2010-09-10.10 2009-08-10.20 When I tried to convert Year_END_Date to character format using select(PLC, format(Year_END_Date,format = "%B %d, %Y"), EPS) I get an error Error: Can't subset

Re: [R] Looping thorugh dataframe

2020-07-22 Thread e-mail ma015k3113 via R-help
Bert, thanks for responding to my email. I do realise that newbie's like my can expect curt answers but not to worry. I am definitely learning 'R' and what I posted are also statements from R. The statements run perfectly well but don't do what I want them to do. My mistake I have posted sample

[R] Looping through a dataframe

2020-07-21 Thread e-mail ma015k3113 via R-help
Dear All, I have a dataframe which has a few thousand companies with unique company numbers and names and each company has data for several years and each year is stored in a separate row. I want to get a total for the number of years of data for each company. When I loop through the data with

Re: [R] Connect to Oracle database via ODBC

2019-08-05 Thread e-mail ma015k3113 via R-help
p@r-project.org mailto:r-help@r-project.org > wrote: > > > > > On Aug 5, 2019, at 7:03 AM, e-mail ma015k3113 via > R-help < r-help@r-project.org mailto:r-help@r-project.org > wrote: > > > > > > Dear All, can anyone point me towards informatio

Re: [R] Connect to Oracle database via ODBC

2019-08-05 Thread e-mail ma015k3113 via R-help
Dear Marc, Thanks-much appreciated Kind regards Ahson > On 05 August 2019 at 12:54 Marc Schwartz wrote: > > > > > On Aug 5, 2019, at 7:03 AM, e-mail ma015k3113 via R-help > > wrote: > > > > Dear All, can anyone point me towards information for connecti

[R] Connect to Oracle database via ODBC

2019-08-05 Thread e-mail ma015k3113 via R-help
Dear All, can anyone point me towards information for connecting to a Oracle instance via DSN. I have already established a ODBC connection. Sorry if this is very elementary-I am just getting started with R after using SAS for almost 2 decades. Kind regards Ahson ___