Why do we use R rather than Excel?

Re:Why do we use R rather than Excel? by FabHK on Sunday July 11, 2021 @10:12AM (#27800976)

Not sure about that. It is my understanding that Excel only tries to guess the type of an input if it has not been explicitly specified by the user.

The problem with "things that look like dates being interpreted as dates" comes from not specifying that a column has type "text".

[ Parent | on HN ]

Re:Why do we use R rather than Excel? by Xelbair on Sunday July 11, 2021 @12:11PM (#27802019)

Even if you do specify a column as a text excel WILL assume that it contains dates sometimes.

Happened to me multiple times, even when i set each cell as a text.

Seems like copypasting a tab separated values resets the cells to their default state.

[ Parent | on HN ]