Harry Potter spells (Harry Potter Wiki)
A list of 301 spells compiled from the fan-written Harry Potter Wiki. Each row gives the spell name, its incantation where known, its type, a short effect and the colour of light it produces.
VISUAL EXPLORATION
Table preview is the curated default for this dataset.
TABLE PREVIEW
Loading preview…
METADATA
DATA DICTIONARY
Spell name; unique in this table.
Spoken incantation. 'Unknown' (about a third of rows) and 'None' are the source's own values.
Spell type such as Charm, Jinx, Curse, Hex or Transfiguration. Some spells list several types.
Short description of what the spell does.
Colour or appearance of the light the spell gives off. 'None' is the source's own value; null means not recorded.
PROVENANCE & LIMITATIONS
Kept every row and column of Spells.csv. Input: Spells.csv, extracted unchanged from archive.zip, which the human downloaded from https://www.kaggle.com/datasets/gulsahdemiryurek/harry-potter-dataset on 2026-11-12 (zip SHA-256 676a2c37ee2f6e48407d66769675c77a9eadc25944c7be69e9ee38dd60e6f741; CSV SHA-256 61ee70090fa533320901f4f21161071931e3eed3751724cc1d29828331a10651, 20645 bytes; the file in the archive is dated 2021-05-14, which gives the version folder). The Kaggle page does not name its source; the human identified it as the Harry Potter Wiki, whose page footer reads 'Community content is available under CC-BY-SA unless otherwise noted'. Rows were not re-checked against the live wiki. 301 source rows, 301 published rows, 0 removed. Cleaning: semicolon-delimited CSV with BOM parsed; non-breaking spaces and line breaks inside cells replaced by a space; wiki footnote markers ('[6]', a dangling '[') removed; blank kept as null; values otherwise unchanged, including source typos. The archive's film dialogue files and shortversioncharacters.csv are not published. License CC BY-SA 3.0 (https://www.fandom.com/licensing). This dataset uses material from the Harry Potter Wiki at Fandom (https://harrypotter.fandom.com) and is licensed under the Creative Commons Attribution-Share Alike License 3.0 (Unported). Share-alike: redistribute this dataset and anything derived from it under the same license.
Processing code: pipeline/sources/harry_potter_wiki/process-wiki-tables.py
- Fan-written wiki content about a fictional work; it is not an official or authoritative source, and the wiki pages may have changed since this file was compiled.
- Compiled by a third party (Kaggle user gulsahdemiryurek) around May 2021 and not re-checked against the live wiki. Source wording and typos are kept.
- 'Unknown' or 'None' (source values) and null (not recorded) are different; filter for both when counting missing values.
- Type and light are free text; a few types are compounds written without a comma (for example 'Transfiguration Jinx').
- Three incantations (Flipendo, Incendio, Verdimillious) are shared by two spell names each.