Contents

Pypi Downloads

Pypi Downloads

Downloaded from the python package index, that is described as a source here.

Entity Relationship Diagram (ERD)

What is an Entity Relationship Diagram (ERD)?

An entity relationship diagram (ERD) shows the relationships of entity sets stored in a database. An entity in this context is an object, a component of data, for example a variable. An entity set is a collection of similar entities. These entities can have attributes that define their properties.

By defining the entities, and their attributes, and showing the relationships between them, an ER diagram illustrates the logical structure of databases.

Each table demonstrates an entity set, where the rows represent the entities. Each entity set contains a primary key (PK) which is unique in the table. A primary key can be one entity, for example, a tax number or a set of entities like longitude and latitude in spatial data.

An entity set may have got a foreign key (FK). It means that the table is connected to another table’s primary key. This relationship can be represented by a line with a sign on its every ending. The sign specifies how many instances of an entity relate to one instance of another entity:

  • double lines (one)

  • branching line (more)

erDiagram package_download { VARCHAR country_code VARCHAR cpu VARCHAR distribution_type VARCHAR installer_name VARCHAR installer_version VARCHAR openssl_version VARCHAR package_version VARCHAR project_name VARCHAR python_implementation_name VARCHAR python_implementation_version VARCHAR setuptools_version VARCHAR sys_distro_name VARCHAR sys_distro_version VARCHAR sys_name DATETIME timestamp }

Exploratory Data Analysis (EDA)

What does exploratory data analysis contain?

These are some summaries of the initial analyses we conducted on the tables of the dataset. They are based on our ideas that we think can be further explored in a research project.

The exploration notebooks can be checked by clicking on the Open Notebook button. If you just want to see the output figures of the analysis, then open them with the Figures button.

Usage Analysis

Open Notebook

../_images/out-11.png ../_images/out-15.png ../_images/out-21.png ../_images/out-25.png
Co-occurrences of operating systems and cpu types
cpu AMD64 None aarch64 arm64 armv7l x86_64
sys_name            
Darwin 0.00% 0.00% 0.00% 0.07% 0.00% 0.48%
Linux 0.00% 0.00% 0.02% 0.00% 0.01% 91.10%
None 0.00% 7.57% 0.00% 0.00% 0.00% 0.00%
Windows 0.76% 0.00% 0.00% 0.00% 0.00% 0.00%

Tables

How should I use this?

Table information

Each table has a Table Profile, generated by pandas-profiling. This includes descriptive statistics based on the table data and metadata, which can save significant time during the pre-analysis. Each profiling contains descriptives of the variables and additionally may show interactions, correlations, missing data information, and samples of the data. To see the profiling click on Open Table Profile.

Furthermore, you can check the first 5 rows of the tables by clicking on the First 5 rows button.

Download links

The table data can be downloaded in CSV format with Download CSV button. Before this step, we recommend checking the table profile!

Updating information

Some datasets are updated periodically. In this case, you can check the updating period at the top of this section.

There is 1 table

Package Download Table

Download CSV

Open Table Profile

Size: 69586 × 15 (9.85 MB)

Last Changed: 2022-11-03 10:35

country_code cpu distribution_type installer_name installer_version openssl_version package_version project_name python_implementation_name python_implementation_version setuptools_version sys_distro_name sys_distro_version sys_name timestamp
0 CN None sdist Browser None None 1.2.2 scikit-mobility None None None None None None 2021-11-11 03:01:34
1 CN None sdist Browser None None 1.2.2 scikit-mobility None None None None None None 2021-11-11 08:25:11
2 CA arm64 sdist pip 21.3.1 OpenSSL 1.1.1l 24 Aug 2021 1.2.2 scikit-mobility CPython 3.9.7 57.4.0 macOS 12.0.1 Darwin 2021-11-11 20:10:37
3 US x86_64 bdist_wheel pip 20.1.1 OpenSSL 1.1.1l 24 Aug 2021 1.1.2 scikit-mobility CPython 3.7.10 47.3.1.post20200616 Ubuntu 20.04 Linux 2021-11-11 15:08:19
4 US x86_64 bdist_wheel pip 20.1.1 OpenSSL 1.1.1l 24 Aug 2021 1.1.2 scikit-mobility CPython 3.7.10 47.3.1.post20200616 Ubuntu 20.04 Linux 2021-11-11 14:57:51

previous

Field Analysis

next

Usage Analysis