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.
Indonesia Berita Terbaru, Indonesia Berita utama
Similar News:Anda juga dapat membaca berita serupa dengan ini yang kami kumpulkan dari sumber berita lain.
San Antonio’s Volare Italian Restaurant holding six-course Art & Tapas dinnerThe $70 ticket price includes a bottle of Buezo 2005 Tempranillo to take home as a souvenir. SanAntonio SATX SanAntonioTX SanAntonioFood SanAntonioRestaurants Tapas SpanishFood
Baca lebih lajut »
Keke Palmer Says Her Yoga Practice Doesn't Have to Result in a Six-PackKeke Palmer shares what has kept her motivated and grounded while racking up her many, many accolades in a recent interview with Women's Health.
Baca lebih lajut »
Here’s what it really takes to get a six-packEverything you need to consider in your quest to get a six-pack
Baca lebih lajut »
Prince Heirs Settle Estate Dispute More Than Six Years After His DeathPrince's family members and advisers have put to rest all remaining issues involving the disbursement of his $156 million in assets.
Baca lebih lajut »
Armed robbers have struck six times on the Near North Side, police sayThe robberies happened in Streeterville, Old Town, and the Clybourn Corridor. Police said they seem to be connected.
Baca lebih lajut »
Six tips for better spreadsheetsMicrosoft 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.
Baca lebih lajut »