Import csv data with readtable is incorrect data.

Using readtable function to input 2 columns data from csv file, but it divide to 3 columns. Here is my data and import table.

T_id_relation = readtable('store_id_relation.csv');

[madhan ravi]

upload your csv file

[Theerawit Tekitchamroon]

Here

Answer 1

[Akira Agata]

Please specify 'Delimiter' option, like:

T = readtable('store_id_relation.csv','Delimiter',',');

The result is as follows.

>> T = readtable('store_id_relation.csv','Delimiter',',')

T =

150×2 table

air_store_id hpg_store_id

______________________ ______________________

'air_63b13c56b7201bd9' 'hpg_4bc649e72e2a239a'

'air_a24bf50c3e90d583' 'hpg_c34b496d0305a809'

'air_c7f78b4f3cba33ff' 'hpg_cd8ae0d9bbd58ff9'

'air_947eb2cae4f3e8f2' 'hpg_de24ea49dc25d6b8'

...