Data entry and cleaning (AFRIMENT INTERN).xlsx

	A	B	C	D	E	F	G
1	BOOK ID	BOOK TITLE	AUTHOR'S NAME	GENRE	PUB. YEAR	PRICE	STOCK QTY
2	BK 001	The Hitchhiker's Guide to the Galaxy	Douglas Adams	Sci-Fi	1979	$ 12.99	25
3	BK 002	Pride and Prejudice	Jane Austen	Fiction	1813	$ 9.50	15
4	BK 003	Sapiens: A Brief History of Humankind	Yuval Noah Harari	Non-Fiction	2014	$ 18.75	30
5	BK 004	1984	George Orwell	Fiction	1949	$ 10.20	10
6	BK 005	The Lord of the Rings	J.R.R. Tolkien	Fantasy	1954	$ 25.00	8
7	BK 006	The Catcher in the Rye	J.D. Salinger	Fiction	1951	$ 11.80	22
8	BK 007	Atomic Habit	James Clear	Self-Help	2018	$ 15.50	40
9	BK 008	The Silent Patient	Alex Michaelides	Mystery	2019	$ 13.99	18
10	BK 009	Dune	Frank Herbert	Sci-Fi	1965	$ 16.25	12
11	BK 010	Educated	Tara Westover	Biography	2018	$ 17.00	28
12	BK 011	The Psychology of Money	Morgan Housel	Finance	2020	$ 14.50	35
13	BK 012	The Midnight Library	Matt Haig	Fiction	2020	$ 12.75	20
14	BK 013	Where the Crawdads Sing	Delia Owens	Mystery	2018	$ 14.00	25
15	BK 014	The Book Thief	Markus Zusak	Historical Fiction	2005	$ 11.00	16
16	BK 015	The Alchemist	Paulo Coelho	Fiction	1988	$ 9.99	30
17	BK 016	Thinking, Fast and Slow	Daniel Kahneman	Psychology	2011	$ 19.95	14
18	BK 017	The Girl with the Dragon Tattoo	Stieg Larsson	Mystery	2005	$ 12.50	22
19	BK 018	The Road	Cormac McCarthy	Fiction	2006	$ 10.75	18
20	BK 019	The Lean Startup	Eric Ries	Business	2011	$ 16.50	15
21	BK 020	The Power of Now	Eckhart Tolle	Self-Help	1997	$ 13.00	28
22	BK 021	The Name of the Wind	Patrick Rothfuss	Fantasy	2007	$ 17.25	10
23	BK 022	The Immortal Life of Henrietta Lacks	Rebecca Skloot	Non-Fiction	2010	$ 15.80	20
24	BK 023	The Martian	Andy Weir	Sci-Fi	2011	$ 14.75	30
25	BK 024	The Nightangle	Kristin Hannah	Historical Fiction	2015	$ 13.50	25
26	BK 025	The Five People You Meet in Heaven	Mitch Albom	Fiction	2003	$ 10.50	18
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100