Microsoft Excel and Google Sheets are powerful and widely used. But there’s a right way and a wrong way to use them, data scientists say.
Christie Bahlai, a computational ecologist at Kent State University in Ohio, has helped to create workshops and teaches courses on best spreadsheet practices for ecologists. She says her number-one piece of advice is to “keep your raw data raw”.Spreadsheets, Bahlai says, are “tactile”: they are user-friendly, intuitive and easily manipulated. But they are also “easy to mess up”, and it is “easy to lose track of what you’ve done”. An errant mouse click can cause data to end up in the wrong place.
“My top piece [of advice] is, do not encode data with colour or formatting, create another column that can be sorted or filtered,” says Mine Çetinkaya-Rundel, a statistician at Duke University in Durham, North Carolina. Luis Verde Arregoitia, a mammalogist at the Institute of Ecology in Veracruz, Mexico, experienced that when he revisited an old collection of biodiversity records. He had highlighted rows in yellow, orange or green to indicate his level of trust in the data. “At this point,” he says, “I don’t really remember the exact colour-coding scheme that I was using.”Data-analysis tools expect spreadsheets to be in a specific format: one row of column titles, no merged cells and one table per page.
Designate a spreadsheet as a ‘code book’ that documents abbreviations, how data were collected, units of measurement, how missing values will be represented, the calculations being performed and any metadata needed to understand, process and maintain the spreadsheet. “Writing a roadmap for yourself is important,” says Çetinkaya-Rundel.
South Africa Latest News, South Africa Headlines
Similar News:You can also read news stories similar to this one that we have collected from other news sources.
Man wins second lottery prize at same location six years apartKevin Miller knows exactly where to go when he wants to win the lottery.
Read more »
Deshaun Watson given six-game suspension over sexual misconduct accusationsWe finally have some clarity on the Deshaun Watson situation.
Read more »
Six shot, one killed in DC shooting: PoliceWASHINGTON — Six men were shot and one was killed in a shooting in northeast Washington, D.C. on Monday, police said.
Read more »
Hong Kong lowers age for Sinovac vaccine shot to six monthsHong Kong on Tuesday reduced the minimum age for getting vaccinated with China's Sinovac COVID-19 shot to six months from three years after several young children became infected with the virus.
Read more »
Six years later, Hillary Clinton's 2016 campaign gravy train is almost dried upHillary Clinton's 2016 presidential campaign used up almost all its remaining cash reserves during the first half of 2022, Federal Election Commission filings show.
Read more »
Prince Estate Court Battle Finally Ends, Six Years LaterThe legendary artist’s vast holdings can now be handed out to his heirs and to Primary Wave. Both sides have vowed to “preserve Prince’s legacy.”
Read more »