SECTION 02 / 13

Meet the datasets: marks, bills and words

2 min read
On this page 4 headings

A dataset is a collection of related items. In this course, each item is drawn as a card. Each card has named fields. Different cards follow the same format, while the field values change.

Bhuvanesh’s actual score card shows how one record groups fields with different types.
Bhuvanesh’s actual score card shows how one record groups fields with different types.
YOUR COURSE DATA · TRY IT HERE

Read the fields and their types

Use the supplied 30 score cards. No download or coding is needed.

READY TO START

A pile of 30 cards

Start with the first card. Read its fields, do one small action, then move on.

What we remember

Read
0

Nothing has been read yet. Choose Next card to begin.

Look through all 30 original records
BhuvaneshMaths 68 · Erode
CardNo
0
Name
Bhuvanesh
Gender
M
DateOfBirth
7 Nov
CityTown
Erode
Mathematics
68
Physics
64
Chemistry
78
Total
210
HarishMaths 62 · Salem
CardNo
1
Name
Harish
Gender
M
DateOfBirth
3 Jun
CityTown
Salem
Mathematics
62
Physics
45
Chemistry
91
Total
198
ShashankMaths 57 · Chennai
CardNo
2
Name
Shashank
Gender
M
DateOfBirth
4 Jan
CityTown
Chennai
Mathematics
57
Physics
54
Chemistry
77
Total
188
RidaMaths 42 · Chennai
CardNo
3
Name
Rida
Gender
F
DateOfBirth
5 May
CityTown
Chennai
Mathematics
42
Physics
53
Chemistry
78
Total
173
RitikaMaths 87 · Madurai
CardNo
4
Name
Ritika
Gender
F
DateOfBirth
17 Nov
CityTown
Madurai
Mathematics
87
Physics
64
Chemistry
89
Total
240
AkshayaMaths 71 · Chennai
CardNo
5
Name
Akshaya
Gender
F
DateOfBirth
8 Feb
CityTown
Chennai
Mathematics
71
Physics
92
Chemistry
84
Total
247
SameerMaths 81 · Ambur
CardNo
6
Name
Sameer
Gender
M
DateOfBirth
23 Mar
CityTown
Ambur
Mathematics
81
Physics
82
Chemistry
87
Total
250
AdityaMaths 84 · Vellore
CardNo
7
Name
Aditya
Gender
M
DateOfBirth
15 Mar
CityTown
Vellore
Mathematics
84
Physics
92
Chemistry
76
Total
252
SuryaMaths 74 · Bengaluru
CardNo
8
Name
Surya
Gender
M
DateOfBirth
28 Feb
CityTown
Bengaluru
Mathematics
74
Physics
64
Chemistry
51
Total
189
ClarenceMaths 63 · Bengaluru
CardNo
9
Name
Clarence
Gender
M
DateOfBirth
6 Dec
CityTown
Bengaluru
Mathematics
63
Physics
88
Chemistry
73
Total
224
KavyaMaths 64 · Chennai
CardNo
10
Name
Kavya
Gender
F
DateOfBirth
12 Jan
CityTown
Chennai
Mathematics
64
Physics
72
Chemistry
68
Total
204
RahulMaths 97 · Bengaluru
CardNo
11
Name
Rahul
Gender
M
DateOfBirth
30 Apr
CityTown
Bengaluru
Mathematics
97
Physics
92
Chemistry
92
Total
281
SrinidhiMaths 52 · Chennai
CardNo
12
Name
Srinidhi
Gender
F
DateOfBirth
14 Jan
CityTown
Chennai
Mathematics
52
Physics
64
Chemistry
71
Total
187
GopiMaths 65 · Madurai
CardNo
13
Name
Gopi
Gender
M
DateOfBirth
6 May
CityTown
Madurai
Mathematics
65
Physics
73
Chemistry
89
Total
227
SophiaMaths 89 · Trichy
CardNo
14
Name
Sophia
Gender
F
DateOfBirth
23 July
CityTown
Trichy
Mathematics
89
Physics
62
Chemistry
93
Total
244
GoutamiMaths 76 · Theni
CardNo
15
Name
Goutami
Gender
F
DateOfBirth
22 Sep
CityTown
Theni
Mathematics
76
Physics
58
Chemistry
90
Total
224
TauseefMaths 87 · Trichy
CardNo
16
Name
Tauseef
Gender
M
DateOfBirth
30 Dec
CityTown
Trichy
Mathematics
87
Physics
86
Chemistry
43
Total
216
ArshadMaths 62 · Chennai
CardNo
17
Name
Arshad
Gender
M
DateOfBirth
14 Dec
CityTown
Chennai
Mathematics
62
Physics
81
Chemistry
67
Total
210
AbiramiMaths 72 · Erode
CardNo
18
Name
Abirami
Gender
F
DateOfBirth
9 Oct
CityTown
Erode
Mathematics
72
Physics
92
Chemistry
97
Total
261
VetrivelMaths 56 · Trichy
CardNo
19
Name
Vetrivel
Gender
M
DateOfBirth
30 Aug
CityTown
Trichy
Mathematics
56
Physics
78
Chemistry
62
Total
196
KalyanMaths 93 · Vellore
CardNo
20
Name
Kalyan
Gender
M
DateOfBirth
17 Sep
CityTown
Vellore
Mathematics
93
Physics
68
Chemistry
91
Total
252
MonikaMaths 78 · Bengaluru
CardNo
21
Name
Monika
Gender
F
DateOfBirth
15 Mar
CityTown
Bengaluru
Mathematics
78
Physics
69
Chemistry
74
Total
221
PriyaMaths 62 · Nagercoil
CardNo
22
Name
Priya
Gender
F
DateOfBirth
17 Jul
CityTown
Nagercoil
Mathematics
62
Physics
62
Chemistry
57
Total
181
DeepikaMaths 97 · Bengaluru
CardNo
23
Name
Deepika
Gender
F
DateOfBirth
13 May
CityTown
Bengaluru
Mathematics
97
Physics
91
Chemistry
88
Total
276
SiddharthMaths 44 · Madurai
CardNo
24
Name
Siddharth
Gender
M
DateOfBirth
26 Dec
CityTown
Madurai
Mathematics
44
Physics
72
Chemistry
58
Total
174
GeetaMaths 87 · Chennai
CardNo
25
Name
Geeta
Gender
F
DateOfBirth
16 May
CityTown
Chennai
Mathematics
87
Physics
75
Chemistry
92
Total
254
JKMaths 74 · Chennai
CardNo
26
Name
JK
Gender
M
DateOfBirth
22 Jul
CityTown
Chennai
Mathematics
74
Physics
71
Chemistry
82
Total
227
JaganMaths 81 · Madurai
CardNo
27
Name
Jagan
Gender
M
DateOfBirth
4 Mar
CityTown
Madurai
Mathematics
81
Physics
76
Chemistry
52
Total
209
NishaMaths 74 · Madurai
CardNo
28
Name
Nisha
Gender
F
DateOfBirth
10 Sep
CityTown
Madurai
Mathematics
74
Physics
83
Chemistry
83
Total
240
NaveenMaths 72 · Vellore
CardNo
29
Name
Naveen
Gender
M
DateOfBirth
13 Oct
CityTown
Vellore
Mathematics
72
Physics
66
Chemistry
81
Total
219
YOUR COURSE DATA · TRY IT HERE

Read the fields on each word card

Use the supplied 65 word cards. No download or coding is needed.

READY TO START

A pile of 65 cards

Start with the first card. Read its fields, do one small action, then move on.

What we remember

Read
0

Nothing has been read yet. Choose Next card to begin.

Look through all 65 original records
ItPronoun · 2 letters
SerialNumber
0
Word
It
PartOfSpeech
Pronoun
LetterCount
2
wasVerb · 3 letters
SerialNumber
1
Word
was
PartOfSpeech
Verb
LetterCount
3
MondayNoun · 6 letters
SerialNumber
2
Word
Monday
PartOfSpeech
Noun
LetterCount
6
morning.Noun · 7 letters
SerialNumber
3
Word
morning.
PartOfSpeech
Noun
LetterCount
7
SwaminathanNoun · 11 letters
SerialNumber
4
Word
Swaminathan
PartOfSpeech
Noun
LetterCount
11
wasVerb · 3 letters
SerialNumber
5
Word
was
PartOfSpeech
Verb
LetterCount
3
reluctantAdjective · 9 letters
SerialNumber
6
Word
reluctant
PartOfSpeech
Adjective
LetterCount
9
toPreposition · 2 letters
SerialNumber
7
Word
to
PartOfSpeech
Preposition
LetterCount
2
openVerb · 4 letters
SerialNumber
8
Word
open
PartOfSpeech
Verb
LetterCount
4
hisPronoun · 3 letters
SerialNumber
9
Word
his
PartOfSpeech
Pronoun
LetterCount
3
eyes.Noun · 4 letters
SerialNumber
10
Word
eyes.
PartOfSpeech
Noun
LetterCount
4
HePronoun · 2 letters
SerialNumber
11
Word
He
PartOfSpeech
Pronoun
LetterCount
2
consideredVerb · 10 letters
SerialNumber
12
Word
considered
PartOfSpeech
Verb
LetterCount
10
MondayNoun · 6 letters
SerialNumber
13
Word
Monday
PartOfSpeech
Noun
LetterCount
6
speciallyAdverb · 9 letters
SerialNumber
14
Word
specially
PartOfSpeech
Adverb
LetterCount
9
unpleasantAdjective · 10 letters
SerialNumber
15
Word
unpleasant
PartOfSpeech
Adjective
LetterCount
10
inPreposition · 2 letters
SerialNumber
16
Word
in
PartOfSpeech
Preposition
LetterCount
2
theArticle · 3 letters
SerialNumber
17
Word
the
PartOfSpeech
Article
LetterCount
3
calendar.Noun · 8 letters
SerialNumber
18
Word
calendar.
PartOfSpeech
Noun
LetterCount
8
AfterPreposition · 5 letters
SerialNumber
19
Word
After
PartOfSpeech
Preposition
LetterCount
5
theArticle · 3 letters
SerialNumber
20
Word
the
PartOfSpeech
Article
LetterCount
3
deliciousAdjective · 9 letters
SerialNumber
21
Word
delicious
PartOfSpeech
Adjective
LetterCount
9
freedomNoun · 7 letters
SerialNumber
22
Word
freedom
PartOfSpeech
Noun
LetterCount
7
ofPreposition · 2 letters
SerialNumber
23
Word
of
PartOfSpeech
Preposition
LetterCount
2
SaturdayNoun · 8 letters
SerialNumber
24
Word
Saturday
PartOfSpeech
Noun
LetterCount
8
AndConjunction · 3 letters
SerialNumber
25
Word
And
PartOfSpeech
Conjunction
LetterCount
3
Sunday,Noun · 6 letters
SerialNumber
26
Word
Sunday,
PartOfSpeech
Noun
LetterCount
6
itPronoun · 2 letters
SerialNumber
27
Word
it
PartOfSpeech
Pronoun
LetterCount
2
wasVerb · 3 letters
SerialNumber
28
Word
was
PartOfSpeech
Verb
LetterCount
3
difficultAdjective · 9 letters
SerialNumber
29
Word
difficult
PartOfSpeech
Adjective
LetterCount
9
toPreposition · 2 letters
SerialNumber
30
Word
to
PartOfSpeech
Preposition
LetterCount
2
getVerb · 3 letters
SerialNumber
31
Word
get
PartOfSpeech
Verb
LetterCount
3
intoPreposition · 4 letters
SerialNumber
32
Word
into
PartOfSpeech
Preposition
LetterCount
4
theArticle · 3 letters
SerialNumber
33
Word
the
PartOfSpeech
Article
LetterCount
3
MondayNoun · 6 letters
SerialNumber
34
Word
Monday
PartOfSpeech
Noun
LetterCount
6
moodNoun · 4 letters
SerialNumber
35
Word
mood
PartOfSpeech
Noun
LetterCount
4
ofPreposition · 2 letters
SerialNumber
36
Word
of
PartOfSpeech
Preposition
LetterCount
2
workNoun · 4 letters
SerialNumber
37
Word
work
PartOfSpeech
Noun
LetterCount
4
andConjunction · 3 letters
SerialNumber
38
Word
and
PartOfSpeech
Conjunction
LetterCount
3
discipline.Noun · 10 letters
SerialNumber
39
Word
discipline.
PartOfSpeech
Noun
LetterCount
10
HePronoun · 2 letters
SerialNumber
40
Word
He
PartOfSpeech
Pronoun
LetterCount
2
shudderedVerb · 9 letters
SerialNumber
41
Word
shuddered
PartOfSpeech
Verb
LetterCount
9
atPreposition · 2 letters
SerialNumber
42
Word
at
PartOfSpeech
Preposition
LetterCount
2
theArticle · 3 letters
SerialNumber
43
Word
the
PartOfSpeech
Article
LetterCount
3
veryAdverb · 4 letters
SerialNumber
44
Word
very
PartOfSpeech
Adverb
LetterCount
4
thoughtNoun · 7 letters
SerialNumber
45
Word
thought
PartOfSpeech
Noun
LetterCount
7
ofPreposition · 2 letters
SerialNumber
46
Word
of
PartOfSpeech
Preposition
LetterCount
2
school:Noun · 6 letters
SerialNumber
47
Word
school:
PartOfSpeech
Noun
LetterCount
6
theArticle · 3 letters
SerialNumber
48
Word
the
PartOfSpeech
Article
LetterCount
3
dismalAdjective · 6 letters
SerialNumber
49
Word
dismal
PartOfSpeech
Adjective
LetterCount
6
yellowAdjective · 6 letters
SerialNumber
50
Word
yellow
PartOfSpeech
Adjective
LetterCount
6
building;Noun · 8 letters
SerialNumber
51
Word
building;
PartOfSpeech
Noun
LetterCount
8
theArticle · 3 letters
SerialNumber
52
Word
the
PartOfSpeech
Article
LetterCount
3
fire-eyedAdjective · 8 letters
SerialNumber
53
Word
fire-eyed
PartOfSpeech
Adjective
LetterCount
8
Vedanayagam,Noun · 11 letters
SerialNumber
54
Word
Vedanayagam,
PartOfSpeech
Noun
LetterCount
11
hisPronoun · 3 letters
SerialNumber
55
Word
his
PartOfSpeech
Pronoun
LetterCount
3
classNoun · 5 letters
SerialNumber
56
Word
class
PartOfSpeech
Noun
LetterCount
5
teacher,Noun · 7 letters
SerialNumber
57
Word
teacher,
PartOfSpeech
Noun
LetterCount
7
andConjunction · 3 letters
SerialNumber
58
Word
and
PartOfSpeech
Conjunction
LetterCount
3
headmasterNoun · 10 letters
SerialNumber
59
Word
headmaster
PartOfSpeech
Noun
LetterCount
10
withPreposition · 4 letters
SerialNumber
60
Word
with
PartOfSpeech
Preposition
LetterCount
4
hisPronoun · 3 letters
SerialNumber
61
Word
his
PartOfSpeech
Pronoun
LetterCount
3
thinAdjective · 4 letters
SerialNumber
62
Word
thin
PartOfSpeech
Adjective
LetterCount
4
longAdjective · 4 letters
SerialNumber
63
Word
long
PartOfSpeech
Adjective
LetterCount
4
cane...Noun · 4 letters
SerialNumber
64
Word
cane...
PartOfSpeech
Noun
LetterCount
4
YOUR COURSE DATA · TRY IT HERE

Read a shopping bill as a record

Use the supplied 30 shopping bills. No download or coding is needed.

READY TO START

A pile of 30 cards

Start with the first card. Read its fields, do one small action, then move on.

What we remember

Read
0

Nothing has been read yet. Choose Next card to begin.

Look through all 30 original records
Bill 1SV Stores · ₹567
BillNo
1
Store
SV Stores
Customer
Srivatsan
BillAmount
567
MajorCategories
Apparel | Food | Toiletries
FoodClass
Mixed
Bill 2Big Bazaar · ₹1525
BillNo
2
Store
Big Bazaar
Customer
Sudeep
BillAmount
1525
MajorCategories
Apparel | Food | Household
FoodClass
Mixed
Bill 3SV Stores · ₹1341
BillNo
3
Store
SV Stores
Customer
Akshaya
BillAmount
1341
MajorCategories
Food | Toiletries
FoodClass
Mixed
Bill 4SV Stores · ₹123
BillNo
4
Store
SV Stores
Customer
Advaith
BillAmount
123
MajorCategories
Food
FoodClass
All food
Bill 5Big Bazaar · ₹4174
BillNo
5
Store
Big Bazaar
Customer
Akshaya
BillAmount
4174
MajorCategories
Apparel | Food | Household
FoodClass
Mixed
Bill 6Sun General · ₹354
BillNo
6
Store
Sun General
Customer
Srivatsan
BillAmount
354
MajorCategories
Electronics | Food | Stationery | Utilities
FoodClass
Mixed
Bill 7SV Stores · ₹96
BillNo
7
Store
SV Stores
Customer
Akhil
BillAmount
96
MajorCategories
Food
FoodClass
All food
Bill 8Big Bazaar · ₹3132
BillNo
8
Store
Big Bazaar
Customer
Advaith
BillAmount
3132
MajorCategories
Apparel | Food | Toiletries
FoodClass
Mixed
Bill 9Big Bazaar · ₹595
BillNo
9
Store
Big Bazaar
Customer
Mohith
BillAmount
595
MajorCategories
Apparel | Food
FoodClass
Mixed
Bill 10Sun General · ₹378
BillNo
10
Store
Sun General
Customer
Rajesh
BillAmount
378
MajorCategories
Food | Stationery
FoodClass
Mixed
Bill 11SV Stores · ₹893
BillNo
11
Store
SV Stores
Customer
Abhinav
BillAmount
893
MajorCategories
Food | Household
FoodClass
Mixed
Bill 12Sun General · ₹186
BillNo
12
Store
Sun General
Customer
Aparna
BillAmount
186
MajorCategories
Food | Household | Stationery
FoodClass
Mixed
Bill 13Big Bazaar · ₹3060
BillNo
13
Store
Big Bazaar
Customer
Abhinav
BillAmount
3060
MajorCategories
Apparel
FoodClass
No food
Bill 14Sun General · ₹656
BillNo
14
Store
Sun General
Customer
Vignesh
BillAmount
656
MajorCategories
Electronics | Grooming | Stationery | Utilities
FoodClass
No food
Bill 15Sun General · ₹229
BillNo
15
Store
Sun General
Customer
Abhinav
BillAmount
229
MajorCategories
Toiletries
FoodClass
No food
Bill 16Sun General · ₹187
BillNo
16
Store
Sun General
Customer
Advaith
BillAmount
187
MajorCategories
Stationery
FoodClass
No food
Bill 17SV Stores · ₹279
BillNo
17
Store
SV Stores
Customer
George
BillAmount
279
MajorCategories
Food
FoodClass
All food
Bill 18SV Stores · ₹603
BillNo
18
Store
SV Stores
Customer
Ahmed
BillAmount
603
MajorCategories
Food
FoodClass
All food
Bill 19SV Stores · ₹592
BillNo
19
Store
SV Stores
Customer
Neeraja
BillAmount
592
MajorCategories
Cosmetics | Food
FoodClass
Mixed
Bill 20SV Stores · ₹622
BillNo
20
Store
SV Stores
Customer
Ahmed
BillAmount
622
MajorCategories
Food | Toiletries
FoodClass
Mixed
Bill 21SV Stores · ₹128
BillNo
21
Store
SV Stores
Customer
Akshaya
BillAmount
128
MajorCategories
Food
FoodClass
All food
Bill 22Sun General · ₹315
BillNo
22
Store
Sun General
Customer
Suresh
BillAmount
315
MajorCategories
Food | Household | Utilities
FoodClass
Mixed
Bill 23SV Stores · ₹888
BillNo
23
Store
SV Stores
Customer
Julia
BillAmount
888
MajorCategories
Food
FoodClass
All food
Bill 24SV Stores · ₹92
BillNo
24
Store
SV Stores
Customer
Neeraja
BillAmount
92
MajorCategories
Food
FoodClass
All food
Bill 25Sun General · ₹1364
BillNo
25
Store
Sun General
Customer
Ahmed
BillAmount
1364
MajorCategories
Accessories | Electronics | Stationery
FoodClass
No food
Bill 26SV Stores · ₹276
BillNo
26
Store
SV Stores
Customer
Srivatsan
BillAmount
276
MajorCategories
Food
FoodClass
All food
Bill 27Sun General · ₹340
BillNo
27
Store
Sun General
Customer
Srivatsan
BillAmount
340
MajorCategories
Household
FoodClass
No food
Bill 28SV Stores · ₹514
BillNo
28
Store
SV Stores
Customer
Vignesh
BillAmount
514
MajorCategories
Food | Toiletries
FoodClass
Mixed
Bill 29SV Stores · ₹106
BillNo
29
Store
SV Stores
Customer
Ahmed
BillAmount
106
MajorCategories
Food
FoodClass
All food
Bill 30Big Bazaar · ₹798
BillNo
30
Store
Big Bazaar
Customer
Radha
BillAmount
798
MajorCategories
Food
FoodClass
All food
Three small teaching cards show fields for a student, a word occurrence and a shopping bill.
Three small teaching cards show fields for a student, a word occurrence and a shopping bill.

Marks cards

A marks card records sequence number, name, group/gender label, date of birth, town/city, maths marks, physics marks, chemistry marks and their total. The sequence number identifies the card. Two students can share a name, so a name alone is not a reliable unique ID.

Shopping bills

A simplified bill records a sequence number, store name, customer name, purchased items and total bill value. Each item row records item name, category, quantity, unit price and cost. The course omits real-bill details such as tax when they are not needed for the task.

ItemCategoryQuantityUnit priceCost
RiceFood2 kgRs 40 per kgRs 80
SoapToiletries3 barsRs 20 per barRs 60
Bill totalRs 140

One bill is one outer record, even though it contains several item rows. “Number of bills”, “number of item rows” and “total purchased quantity” are different questions.

Word cards

The lecture takes words from a paragraph and creates one card per occurrence. A word card stores its position, word text, part-of-speech category and letter count. Repeated words get separate cards because they occur at different positions. Punctuation stays attached to the word in the lecture dataset.

For the teaching word “bright”, the category is Adjective and letter count is 6. For “open”, the part of speech depends on the sentence: “open the door” uses a verb, while “the door is open” uses an adjective.

The questions determine the fields you need

QuestionRelevant fields
What is the average maths mark?Maths marks across marks cards.
How much did one customer spend at one store?Customer, store and bill total.
How many long adjectives occur?Category and letter count.
How many sentences are there?Word order and a defined sentence-ending rule.

Try it yourself

A paragraph contains “it” twice. Should there be one card or two?

Show explained answer

Two occurrence cards. Their text matches, but their positions differ. Collapsing them would change the word count.

Try it yourself

A shopping bill has five item rows. How many bills does that represent?

Show explained answer

One bill, containing a list of five item rows. Count the outer record or the inner rows according to the question.

Try it yourself

Which field helps distinguish two students both called Ravi?

Show explained answer

A unique sequence number or ID. A name can be shared by different people.

Try it yourself

Three soaps cost Rs 20 each. Find the item cost.

Show explained answer

Quantity × unit price = 3×20 = Rs 60. Check that the quantity and unit price refer to the same unit.

Source: Lecture 1.1 — Introduction to datasets. Small teaching datasets and diagrams are prepared for these notes; lecture and tutorial totals are identified explicitly.

YOUR STUDY PROGRESS

Finished this section? Save your progress.

Back to top ↑