Analyze data with public datasets

更新时间:
复制 MD 格式

You can select a public dataset, run the sample SQL, and generate charts and reports from the query results to get started with DataWorks.

List of public datasets

Type

Dataset

Description

Type

Digital Commerce

Alibaba E-commerce Dataset

From the Tianchi Alibaba Mobile Recommendation Algorithm Challenge, this dataset contains one million anonymized records of Alibaba product data. Query fields related to products, user actions, and time to explore the big data analysis capabilities of Alibaba Cloud.

Static data

Taobao Advertising Dataset

Based on Taobao display ad click data, this dataset contains 26 million records from a random sample of 1.14 million users' ad impression and click logs over an 8-day period. For field definitions, see the table details.

Static data

Taobao Shopping Dataset

This dataset contains 100,150,807 behavior records from 987,994 anonymized users and 4,162,024 products, recorded between November 25, 2017, and December 3, 2017. User behaviors include clicks, purchases, adding items to the cart, and adding items to favorites.

Static data

Lifestyle Services

Tourism Data of Districts and Counties in Hangzhou

Sourced from the Hangzhou Culture and Tourism Data Online Open Platform (data updated to July 18, 2023), this dataset includes daily tourism indicators for districts and counties in Hangzhou, such as the number of consumers, spending amounts, and hotel occupancy rates. You can use this dataset to analyze travel patterns and consumer trends for trip-planning scenarios.

Dynamic data

Alibaba Music Dataset

From the Tianchi "Alibaba Music Trending Prediction" Challenge, this dataset was jointly provided by Tsinghua University and Alibaba Cloud. Based on historical playback data from Alibaba Music users, it allows you to analyze listening volumes for artists and predict music trends.

Static data

Global Electric Vehicle Dataset

This dataset contains global statistics on electric vehicles (EVs) and charging stations by country and region from 2010 to 2022. It includes annual metrics such as the number of EVs sold, the number of charging stations, and the total electricity demand from EVs. You can use this data to analyze global EV demand and usage and forecast future trends.

Static data

Gross Regional Product Dataset of the Chinese mainland

This dataset includes annual gross regional product data for provinces in the Chinese mainland (excluding Hong Kong, Macao, and Taiwan) from 2003 to 2022. You can query by province name and year to explore changes in per capita gross regional product, value added of the primary sector, industrial value added, and value added of wholesale and retail.

Static data

Fliggy Recommendation Dataset

This dataset contains anonymized user behavior data from the Fliggy platform, including anonymized user profile attributes and product attributes. You can analyze, predict, and recommend user interests based on behavior data for individual users or user groups.

Static data

Asian Games Medal Dataset

This dataset contains medal counts for all participating countries and regions in every Asian Games from 1951 to 2022.

Dynamic data

Technology and Education

GitHub Event Dataset

This dataset contains public event data recorded by GitHub, including information about the event type (for example, starring a repository or committing code), the developer, and the repository.

Dynamic data

QS World University Rankings

Sourced from the official QS Top Universities website, this dataset covers world university rankings from 2022 to 2024. It includes quantifiable metrics for each institution, such as overall score, academic reputation, and international student ratio. You can analyze ranking changes and performance trends across different dimensions.

Dynamic data

Patent Application and Grant Dataset of the Chinese mainland

This dataset includes patent application and grant data for the three major patent types across provinces in the Chinese mainland (excluding Hong Kong, Macao, and Taiwan) from 2003 to 2021. You can query by province name and year to explore trends in application and grant volumes for invention patents, utility model patents, and design patents.

Dynamic data

Prerequisites

  • You have activated DataWorks and created a data source.

    Note

    You can analyze public datasets using MaxCompute, Hologres, or EMR Spark. You only need to create a data source for one of these services.

  • Ensure network connectivity between the Serverless resource group bound to DataWorks and your MaxCompute, Hologres, or EMR Spark data source. For more information, see Configure network connectivity.

Explore a dataset

  1. Log on to the DataWorks console. In the left-side navigation pane, click Quick Start > DataWorks Gallery. Then, in the Public Dataset section, select Public Dataset.

  2. View the public datasets.

    Click a dataset card to open its details page. For a list of supported public datasets, see List of public datasets. This topic uses the Alibaba E-commerce Dataset as an example. On the right, click Start Analysis and select an existing data source, such as MaxCompute.

  3. DataWorks automatically opens the data analysis module and populates the sample SQL query. In the upper-right corner, switch to your bound MaxCompute data source, and then click Run.

  4. View the chart in the query result.

    The query result is a bar chart showing the Total page views in different time periods. The x-axis represents four-hour time intervals (00:00-03:59, 04:00-07:59, 08:00-11:59, 12:00-15:59, 16:00-19:59, and 20:00-23:59), and the y-axis represents the total page views. The highest traffic period is 20:00-23:59, with approximately 350 million views.

Note

You can also explore other features in the data analysis module, such as enhanced analysis and data profiling. For more information, see Data analysis.

What to do next

After you import a public dataset into the DataWorks data analysis module, you can create data cards and data reports based on the dataset. You can also share these reports with others with a single click. For details, see Visualize with cards and reports.

References

For detailed steps on using public datasets, see Big data and AI public dataset analysis.