Page 1 of 1

Data for all recipes?

Posted: Fri Oct 09, 2020 4:48 am
by ming.yuan
Do we have a collection of all recipes for data analytic purpose?
I want to identify some more commonly used items for better base layout.
I can see that planning mods like Helmod can extract modded recipes. But I do not know how to get them outside of the game
Any help?

Re: Data for all recipes?

Posted: Fri Oct 09, 2020 2:35 pm
by darkfrei
ming.yuan wrote: Fri Oct 09, 2020 4:48 am Do we have a collection of all recipes for data analytic purpose?
I want to identify some more commonly used items for better base layout.
I can see that planning mods like Helmod can extract modded recipes. But I do not know how to get them outside of the game
Any help?
What format are you need? You can get all recipes (and all prototypes) with this mod: viewtopic.php?t=45107

Json: https://mods.factorio.com/query/json?version=1.0

Re: Data for all recipes?

Posted: Sat Oct 10, 2020 4:05 am
by ming.yuan
Thanks! I loaded the recipes into json an then transform from json to Excel. Thank you. New skills learned

Re: Data for all recipes?

Posted: Sat Oct 10, 2020 5:02 am
by ming.yuan
I uploaded the file I get from json. Should include recipes for all pymods (raw ore, coal, industry, alienlife, etc), up to the pyalienlife 1.9.3 version. (most recent as at 9 Oct 2020).
There would be some recipes for utilities mods like electric trains, teleporters, and other items. The impact of these recipes should be trivial on the overall statistic.
I include a very brief analysis of most commonly used ingredients, depending on how many recipes in which the ingredient is used.
Feel free to grab.

Re: Data for all recipes?

Posted: Sat Oct 10, 2020 2:53 pm
by Squelch
Thank you for your efforts.

Just a heads up for anyone without MS Excel. The spreadsheet does not display when imported into Google Sheets. It does however load correctly in LibreOffice, and presumably OpenOffice too.

Re: Data for all recipes?

Posted: Thu Aug 10, 2023 8:34 pm
by Xetrius
ming.yuan wrote: Sat Oct 10, 2020 4:05 am Thanks! I loaded the recipes into json an then transform from json to Excel. Thank you. New skills learned
Care to share?