xinyongtian

read_excel() converts date to number

3

test1.xlsx  I try to covert test1.xlsx to .csv file by using read_excel(), then write.csv() The excel file test1.xlsx contains date column (DOB) with some typo. After read, the correct...

The previous one could not extract data.frame name properly, e.g. not working on subquery.

> duckdf("select * from (SELECT mpg, cyl FROM mtcars WHERE disp >= 200) a") Error in get(from_df_first) : object 'SELECT' not found