I have a csv file that looks like this (see below first few lines of the data) and I've used this line to import it,
read.csv2('hospital_finance_2008.csv', sep=';', check.names = F)
But it all came in one column only. Also how to get rid of the quotations when the first variable doesn't have them?
Content of .csv:
Estabelecimento - CNES;"Privado com fins lucrativos clientela mista";"Privado com fins lucrativos clientela privada";"Privado sem fins lucrativos clientela mista";"Privado sem fins lucrativos clientela privada";"Público clientela fechada";"Público clientela mista";"Público clientela SUS";"Total"
0000027 CASA DE SAUDE SANTA HELENA;"1";"0";"0";"0";"0";"0";"0";"1"
0000035 HOSPITAL MENDO SAMPAIO;"0";"0";"0";"0";"0";"0";"1";"1"
0000094 MATERNIDADE PADRE GERALDO LEITE BASTOS;"0";"0";"0";"0";"0";"0";"1";"1"
0000183 HOSPITAL SAMARITANO;"0";"1";"0";"0";"0";"0";"0";"1"
0000221 HOSPITAL SAO SEBASTIAO;"0";"1";"0";"0";"0";"0";"0";"1"
0000396 HOSPITAL DAS CLINICAS;"0";"0";"0";"0";"0";"0";"1";"1"
0000418 HOSPITAL AGAMENON MAGALHAES;"0";"0";"0";"0";"0";"0";"1";"1"
0000426 HOSPITAL OTAVIO DE FREITAS;"0";"0";"0";"0";"0";"0";"1";"1"
0000434 IMIP;"0";"0";"1";"0";"0";"0";"0";"1"
0000477 HOSPITAL OSWALDO CRUZ;"0";"0";"0";"0";"0";"0";"1";"1"
0000485 FUNDACAO ALTINO VENTURA;"0";"0";"1";"0";"0";"0";"0";"1"