Displaying 5 results from an estimated 5 matches for "stocktab".
Did you mean:
stockar
2025 Jan 28
2
R CMD check says no visible binding for global variable
Data.frame is returned by SQL query. It does have column names. In the function, I make small changes to some columns.
Something like:
Myquery <- ?SELECT date, price, stock FROM stocktab WHERE stock = ?ABC? AND date > ?2025-01-01?;?
Prices <- dbGetQuery(con, myquery)
SetDT(Prices)
Prices[, date = as.Date(date)]
R CMD check say ?no visible binding for global variable ?date??
Sent from my iPhone
On Jan 28, 2025, at 1:24?AM, Sorkin, John <jsorkin at som.umaryland.edu>...
2025 Jan 28
1
R CMD check says no visible binding for global variable
On 2025-01-28 1:55 p.m., Naresh Gurbuxani wrote:
> Data.frame is returned by SQL query. It does have column names. In the function, I make small changes to some columns.
>
> Something like:
>
> Myquery <- ?SELECT date, price, stock FROM stocktab WHERE stock = ?ABC? AND date > ?2025-01-01?;?
>
> Prices <- dbGetQuery(con, myquery)
> SetDT(Prices)
> Prices[, date = as.Date(date)]
If Prices were a regular dataframe at this point, then the message would
be correct. You can't calculate `as.Date(date)` without telling R w...
2025 Jan 28
1
R CMD check says no visible binding for global variable
...ncan at gmail.com> wrote:
>
> ?On 2025-01-28 1:55 p.m., Naresh Gurbuxani wrote:
>> Data.frame is returned by SQL query. It does have column names. In the function, I make small changes to some columns.
>> Something like:
>> Myquery <- ?SELECT date, price, stock FROM stocktab WHERE stock = ?ABC? AND date > ?2025-01-01?;?
>> Prices <- dbGetQuery(con, myquery)
>> SetDT(Prices)
>> Prices[, date = as.Date(date)]
>
> If Prices were a regular dataframe at this point, then the message would be correct. You can't calculate `as.Date(date)` with...
2025 Jan 28
2
R CMD check says no visible binding for global variable
...ncan at gmail.com> wrote:
>
> ?On 2025-01-28 1:55 p.m., Naresh Gurbuxani wrote:
>> Data.frame is returned by SQL query. It does have column names. In the function, I make small changes to some columns.
>> Something like:
>> Myquery <- ?SELECT date, price, stock FROM stocktab WHERE stock = ?ABC? AND date > ?2025-01-01?;?
>> Prices <- dbGetQuery(con, myquery)
>> SetDT(Prices)
>> Prices[, date = as.Date(date)]
>
> If Prices were a regular dataframe at this point, then the message would be correct. You can't calculate `as.Date(date)` with...
2025 Jan 28
1
R CMD check says no visible binding for global variable
There you go, once again helping strengthen ;)
John
Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: R-help <r-help-bounces at r-project.org> on behalf of avi.e.gross at gmail.com <avi.e.gross at gmail.com>
Sent: Tuesday, January 28, 2025 12:01:25 AM
To: 'Naresh Gurbuxani' <naresh_gurbuxani at hotmail.com>; r-help at r-project.org