Just out of interest, I used team up kiosk to farm lore. If you look at the badges - it keeps track of how many times you have attacked. Ok, sometimes I didn't get credit if someone fled or whatever, and sometimes I used team up for other places, but the numbers are pretty close. I didn't include reindeer or Krampus because they are seasonal and have clearly higher drop rates.
Wizard 1 - 1811 attempts (yes, sad but true). 17 spells (1 per 106 attempts). 6 pigsie TC (1 per 302)
Wizard 2- 692 attempts - 6 spells (1 per 115), 3 pigsie tc (1 per 230)
Wizard 3 - 386 attempts - 2 spells (1 per 193), 1 pigsie tc (1 per 386)
overall - 2889 attempts, 25 spells (1 per 115), 10 pigsie tc (1 per 289)
So to get all 19 spells, you can expect about 115 * 19 (not including Krampus and reindeer) = 2185 attempts To get 10 pigsie tc you could expect 10 * 289 = 2890 attempts.
No wonder everyone begs for Pigise TC - you can expect to get all 19 spells before you get enough pigsie tc to craft yourself!