This is really smart, had no idea or could be used this way.

Then again, he doesn't use an unnecessary list comprehension

There is a simpler method. First, it is enough to create a list, although a dict can also be created using this method.
You wrap what you copied from the site in quotes, and then work with the result as a string.
With the help of regular expressions, you remove all unnecessary things - numbers, hyphenation - leaving only the names of the fruits and the spaces between them.
And finally, you can use the usual replace, replacing spaces with quotation marks, commas, and spaces.

Clever solution!

Very nice. Concise and easy to understand :)

This is a great use of Excel. I'm not quite sure why you populate column B with a : instead of just using ":" in the concat function, though. Since the trailing comma is fine, syntactically, and sometimes even desirable, I wouldn't have bothered with the IF statement at the end.

Since I'm now critiquing it, I'll also point out that it only works (as written) for numeric keys and string values. (You could have colume D be key:value, E be "key":value and F be key:"value" and just pick the column you want, or you could get really fancy with ifs in the concat statement to allow a mix of types...)

Anyway, all criticism aside, Excel is a fantastic tool for repetitive programming tasks and thanks for sharing your technique.

When creating large dictionaries, I use Excel.

Example:

A1 = key, B1 = : , C1 = value

Copy for each set (next set would be in row 2, then 3 and so on)

D1 = CONCAT(A1,B1,CHAR(34),C1,CHAR(34),IF(D2="","",","))

---Hold the bottom right corner of D1 and drag down to Auto-Fill (in my example, drag to D5)

---result is key:"value" if the cell below is empty, otherwise it will be key:"value",

---CHAR(34) is for the quotes

Code=CONCAT(A1,B1,CHAR(34),C1,CHAR(34),IF(D2="","",","))

Example= key + : + " + value + " + (if cell below is empty: "" else ",") = key:"value",

E1 = CONCAT("{",D1:D5,"}") #D5 would be my last row

result = {key:"value",key:"value",key:"value"...}

Keep the sheet and re-use for other dictionaries. Just update the D1:D5 range.

Let me show you for this kata:

A1 = 1, B1 = : C1 = "kiwi" and so on...

result={1:"kiwi",2:"pear",3:"kiwi",4:"banana",5:"melon"}

nice one

hmmmmmmmmmmmmmmmmmm

Late reply, but you subtract one number from the "num_pill" since there exist only one space/distance in between two pillars. Same as all real life objects, there exist only one space in between two objects.

Kata's naming is overcomplicated i guess. There is standart names for variables in Physics.

As I know, at first, possible errors, non-standard situations are written in the if block.

number of pillars (≥ 1) is given to us. We have no need to check it in our code

best