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