Streamlined Data Ingestion with pandas
Learn to acquire data from common file formats and systems such as CSV files, spreadsheets, JSON, SQL databases, and APIs.
Comienza El Curso Gratis4 horas16 vídeos53 ejercicios52.539 aprendicesDeclaración de cumplimiento
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.¿Entrenar a 2 o más personas?
Probar DataCamp for BusinessPreferido por estudiantes en miles de empresas
Descripción del curso
Before you can analyze data, you first have to acquire it. This course teaches you how to build pipelines to import data kept in common storage formats. You’ll use pandas, a major Python library for analytics, to get data from a variety of sources, from spreadsheets of survey responses, to a database of public service requests, to an API for a popular review site. Along the way, you’ll learn how to fine-tune imports to get only what you need and to address issues like incorrect data types. Finally, you’ll assemble a custom dataset from a mix of sources.
¿Entrenar a 2 o más personas?
Obtén a tu equipo acceso a la plataforma DataCamp completa, incluidas todas las funciones.En las siguientes pistas
- 1
Importing Data from Flat Files
GratuitoPractice using pandas to get just the data you want from flat files, learn how to wrangle data types and handle errors, and look into some U.S. tax data along the way.
- 2
Importing Data From Excel Files
Automate data imports from that staple of office life, Excel files. Import part or all of a workbook and ensure boolean and datetime data are properly loaded, all while learning about how other people are learning to code.
Introduction to spreadsheets50 xpGet data from a spreadsheet100 xpLoad a portion of a spreadsheet100 xpGetting data from multiple worksheets50 xpSelect a single sheet100 xpSelect multiple sheets100 xpWork with multiple spreadsheets100 xpModifying imports: true/false data50 xpSet Boolean columns100 xpSet custom true/false values100 xpModifying imports: parsing dates50 xpParse simple dates100 xpGet datetimes from multiple columns100 xpParse non-standard date formats100 xp - 3
Importing Data from Databases
Combine pandas with the powers of SQL to find out just how many problems New Yorkers have with their housing. This chapter features introductory SQL topics like WHERE clauses, aggregate functions, and basic joins.
Introduction to databases50 xpConnect to a database100 xpLoad entire tables100 xpRefining imports with SQL queries50 xpSelecting columns with SQL100 xpSelecting rows100 xpFiltering on multiple conditions100 xpMore complex SQL queries50 xpGetting distinct values100 xpCounting in groups100 xpWorking with aggregate functions100 xpLoading multiple tables with joins50 xpJoining tables100 xpJoining and filtering100 xpJoining, filtering, and aggregating100 xp - 4
Importing JSON Data and Working with APIs
Learn how to work with JSON data and web APIs by exploring a public dataset and getting cafe recommendations from Yelp. End by learning some techniques to combine datasets once they have been loaded into data frames.
Introduction to JSON50 xpLoad JSON data100 xpWork with JSON orientations100 xpIntroduction to APIs50 xpGet data from an API100 xpSet API parameters100 xpSet request headers100 xpWorking with nested JSONs50 xpFlatten nested JSONs100 xpHandle deeply nested data100 xpCombining multiple datasets50 xpConcatenate dataframes100 xpMerge dataframes100 xpWrap-up50 xp
¿Entrenar a 2 o más personas?
Obtén a tu equipo acceso a la plataforma DataCamp completa, incluidas todas las funciones.En las siguientes pistas
conjuntos de datos
Vermont tax return data by ZIP codeFreeCodeCamp New Developer Survey response subsetNYC weather and 311 housing complaintscolaboradores
Amany Mahfouz
Ver Más
Data scientist via spatial analytics and geography.
¿Qué tienen que decir otros alumnos?
¡Únete a 15 millones de estudiantes y empieza Streamlined Data Ingestion with pandas hoy mismo!
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.