April 2025
Intermediate to advanced
578 pages
13h 35m
Portuguese (Portugal, Brazil)
Content preview from R for Data Science, 2ª Edição
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Capítulo 20. Folhas de cálculo
Este trabalho foi traduzido com recurso a IA. Agradecemos o teu feedback e comentários: translation-feedback@oreilly.com
Introdução
No Capítulo 7, aprendeste a importar dados de ficheiros de texto simples, como .csv e .tsv. Agora está na altura de aprenderes a obter dados de uma folha de cálculo, seja uma folha de cálculo do Excel ou uma folha de cálculo do Google. Isto basear-se-á em muito do que aprendeste no Capítulo 7, mas também discutiremos considerações e complexidades adicionais ao trabalhar com dados de folhas de cálculo.
Se tu ou os teus colaboradores estão a utilizar folhas de cálculo para organizar dados, recomendamos vivamente a leitura do documento "Data Organization in Spreadsheets" (Organização de dados em folhas de cálculo) de Karl Broman e Kara Woo. As melhores práticas apresentadas neste documento poupar-te-ão muitas dores de cabeça quando importares dados de uma folha de cálculo para o R para análise e visualização.
Excel
O Microsoft Excel é um programa de software de folha de cálculo muito utilizado, em que os dados são organizados em folhas de cálculo dentro de ficheiros de folha de cálculo.
Pré-requisitos
Nesta secção, aprenderás a carregar dados de folhas de cálculo do Excel em R com o pacote readxl. Este pacote é noncore tidyverse, por isso tens de o carregar explicitamente, mas é instalado automaticamente quando instalas o pacote tidyverse. Mais tarde, utilizaremos também o pacote writexl, que nos permite criar folhas ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.