Assuming that the list of host names is called hostlist and the CSV file is pings.csv :
while read -r h; do ping -c 10 $h; done<hostlist | awk 'BEGIN{printf "host,min,avg,max\n"} /PING/{host=$2}; $1=="rtt"{split($4,a,"/");printf "%s,%s,%s,%s\n",host,a[1],a[2],a[3]}' > pings.csv