How often should one visit someone in the hospital?

My dearest elderly friend will require a 10 day hospital stay. He has no family nearby , so I will be his primary visitor. I work full time and have a child to take care of along with all the other life/housekeeping things. My question is should I be trying to find a way to visit every day?The hospital is a train ride away, and I do not drive. What do you all think is reasonable? I think going every day will be a large challenge, but I feel sad that I would probably be the only visitor.