How to add a column in a table using R script?

[Anonymous]

I would like to add an extra column in an existing table and I want that column to be filled with the following text "YTD".

output <- as.data.frame(dataset, stringsAsFactors = FALSE, row.names=NULL)
output$F <- "YTD"

 I get following error message:

DataSource.Error: ADO.NET: R script error.
Error in read.table(file = file, header = header, sep = sep, quote = quote,  : 
  duplicate 'row.names' are not allowed
Calls: read.csv -> read.table
Execution halted

Details:
    DataSourceKind=R
    DataSourcePath=R
    Message=R script error.
Error in read.table(file = file, header = header, sep = sep, quote = quote,  : 
  duplicate 'row.names' are not allowed
Calls: read.csv -> read.table
Execution halted

    ErrorCode=-2147467259
    ExceptionType=Microsoft.PowerBI.Scripting.R.Exceptions.RScriptRuntimeException

Any help will be appreciated

[Anonymous]

Hi.

I have a similar problem. I want to add a new column in a table using Power Bi but I don't know how!

The script code is: 

# new variable

dataset$new <- 0

f=nrow(dataset)

for (i in 2:f) {

if( dataset$num[i-1] == dataset$num[i] ) {
dataset$new[i-1] = dataset$start [i-1] - dataset$end[i] - 1

}

else { dataset$new[i-1] = "NO"
}
}

How can I insert this code?

Could help me, please?

Many thanks,

regards.

[v-xicai]

Hi @Anonymous ,

For the error "duplicate 'row.names' are not allowed ", you can refer to the similar cases:

https://stackoverflow.com/questions/8854046/duplicate-row-names-are-not-allowed-error ,

https://stackoverflow.com/questions/15285089/r-duplicate-row-names-are-not-allowed.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.