Build a bash script to parse yaml file and pull the required key values to csv

Below is the conditions

Taking the salt_master.sls file as an input, export a csv that has the below columns

vmname owner environment OS roles applications custom_grains

The field will be derived by:

vmname: salt-name

owner: [platform, bussys, database,devops,prodops,other, orphaned]
if custom_grains.owner==platform, platform
if grains.applications == bussys*, bussys
find pattern for most devops
find pattern for most prodops
if nothing, owner is orphaned

environment:which pillar is this

OS:
if name contains '.ad.peapod.com' windows

roles:
grains.role

applications:
grains.applications

custom_grains:
a concatinated text list of the custom grain pairs.
thing1:stuff thing2:otherstuff thing3:morestuff
always lowercase
space delimited

General:
all field other then name:
should be lower case.
use '_' instead of space or comma
no symbols other then _ are allowed
no icinga grains