{ "cells": [ { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import random" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [], "source": [ "names = [\"Albert\",\"John\",\"Richard\",\"Henry\",\"William\"]\n", "surnames = [\"Goodman\",\"Black\",\"White\",\"Green\",\"Joneson\"]\n", "salaries = [500*random.randint(10,30) for _ in range(10)]" ] }, { "cell_type": "code", "execution_count": 25, "metadata": {}, "outputs": [], "source": [ "def generate_random_person(names, surnames, salaries):\n", " return {\"name\":random.sample(names,1)[0],\n", " \"surname\":random.sample(surnames,1)[0],\n", " \"salary\":random.sample(salaries,1)[0]}\n", "def generate_people(k):\n", " return [generate_random_person(names, surnames, salaries) for _ in range(k)]" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'name': 'Richard', 'salary': 7500, 'surname': 'Joneson'}" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "generate_random_person(names, surnames, salaries)" ] }, { "cell_type": "code", "execution_count": 28, "metadata": {}, "outputs": [], "source": [ "df = pd.DataFrame(generate_people(50),columns=[\"name\",\"surname\",\"salary\"])" ] }, { "cell_type": "code", "execution_count": 29, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | name | \n", "surname | \n", "salary | \n", "
---|---|---|---|
0 | \n", "Henry | \n", "Goodman | \n", "7500 | \n", "
1 | \n", "Henry | \n", "Black | \n", "9500 | \n", "
2 | \n", "William | \n", "Goodman | \n", "7000 | \n", "
3 | \n", "John | \n", "Black | \n", "6000 | \n", "
4 | \n", "Albert | \n", "White | \n", "9500 | \n", "
5 | \n", "William | \n", "Goodman | \n", "7500 | \n", "
6 | \n", "Richard | \n", "Green | \n", "12500 | \n", "
7 | \n", "Albert | \n", "Goodman | \n", "7500 | \n", "
8 | \n", "Albert | \n", "Joneson | \n", "12500 | \n", "
9 | \n", "Richard | \n", "Black | \n", "6000 | \n", "
10 | \n", "William | \n", "Green | \n", "7500 | \n", "
11 | \n", "William | \n", "Joneson | \n", "6000 | \n", "
12 | \n", "William | \n", "Joneson | \n", "7500 | \n", "
13 | \n", "Richard | \n", "Green | \n", "7000 | \n", "
14 | \n", "Henry | \n", "Goodman | \n", "9500 | \n", "
15 | \n", "Richard | \n", "Joneson | \n", "6000 | \n", "
16 | \n", "William | \n", "Green | \n", "8500 | \n", "
17 | \n", "John | \n", "Green | \n", "7500 | \n", "
18 | \n", "Henry | \n", "White | \n", "9500 | \n", "
19 | \n", "John | \n", "Joneson | \n", "7000 | \n", "
20 | \n", "Albert | \n", "Black | \n", "7500 | \n", "
21 | \n", "Richard | \n", "White | \n", "7500 | \n", "
22 | \n", "Richard | \n", "Black | \n", "8500 | \n", "
23 | \n", "Henry | \n", "Goodman | \n", "7500 | \n", "
24 | \n", "Henry | \n", "Black | \n", "7000 | \n", "
25 | \n", "John | \n", "Green | \n", "11500 | \n", "
26 | \n", "John | \n", "Black | \n", "8500 | \n", "
27 | \n", "Albert | \n", "Green | \n", "11500 | \n", "
28 | \n", "John | \n", "Goodman | \n", "7500 | \n", "
29 | \n", "John | \n", "White | \n", "11500 | \n", "
30 | \n", "William | \n", "White | \n", "7000 | \n", "
31 | \n", "John | \n", "White | \n", "9500 | \n", "
32 | \n", "Albert | \n", "Green | \n", "9500 | \n", "
33 | \n", "William | \n", "Green | \n", "6000 | \n", "
34 | \n", "William | \n", "Black | \n", "7000 | \n", "
35 | \n", "Henry | \n", "White | \n", "7000 | \n", "
36 | \n", "Albert | \n", "Black | \n", "7000 | \n", "
37 | \n", "John | \n", "Goodman | \n", "7500 | \n", "
38 | \n", "Richard | \n", "White | \n", "11500 | \n", "
39 | \n", "Richard | \n", "Goodman | \n", "7000 | \n", "
40 | \n", "Henry | \n", "Green | \n", "7500 | \n", "
41 | \n", "Richard | \n", "Goodman | \n", "8500 | \n", "
42 | \n", "William | \n", "White | \n", "11500 | \n", "
43 | \n", "John | \n", "Black | \n", "12500 | \n", "
44 | \n", "John | \n", "Green | \n", "7500 | \n", "
45 | \n", "Richard | \n", "Joneson | \n", "8500 | \n", "
46 | \n", "William | \n", "Goodman | \n", "9500 | \n", "
47 | \n", "William | \n", "White | \n", "6000 | \n", "
48 | \n", "Albert | \n", "Black | \n", "7000 | \n", "
49 | \n", "William | \n", "Green | \n", "12500 | \n", "