Return to Question

I have a csv file that has 7 columns. It has empty cells and some spaces between cells. How can I replace the empty cells with NA and remove extra spaces? Thank you very much!

Here is what my file looks like, but here it seems to warp around when I copy and past it.

130070078,PPW0001,1,4,4HW ,2,15.61943874 120040039,PPW0002,0,0, ,0,0 120040043,PPW0003,1,3,3WE ,1,14.43394935

I have a csv file that has 7 columns. It has empty cells and some spaces between cells. How can I replace the empty cells with NA and remove extra spaces? Thank you very much!

Here is what my file looks like, but here it seems to warp around when I copy and past it.

130070078,PPW0001,1,4,4HW             ,2,15.61943874
120040039,PPW0002,0,0,                ,0,0
120040043,PPW0003,1,3,3WE             ,1,14.43394935

I have a csv file that has 7 columns. It has empty cells and some spaces between cells. How can I replace the empty cells with NA and remove extra spaces? Thank you very much!

Here is what my file looks like:

130070078,PPW0001,1,4,4HW ,2,15.61943874 120040039,PPW0002,0,0, ,0,0 120040043,PPW0003,1,3,3WE ,1,14.43394935 110030030,PPW0004,1,2,2L2M2 ,2,13.75770021 110030032,PPW0005,1,2,2L2M2 ,1,13.70568104 110030033,PPW0006,1,2,2L2M2 ,2,12.56399726 110030037,PPW0007,1,2,2L2M2 ,2,14.22313484 120050053,PPW0008,0,0, ,0,0 120050054,PPW0009,1,3,3WE ,2,16.06297057

I have a csv file that has 7 columns. It has empty cells and some spaces between cells. How can I replace the empty cells with NA and remove extra spaces? Thank you very much!

Here is what my file looks like, but here it seems to warp around when I copy and past it.

130070078,PPW0001,1,4,4HW ,2,15.61943874 120040039,PPW0002,0,0, ,0,0 120040043,PPW0003,1,3,3WE ,1,14.43394935

I have a csv file that has 7 columns. It has empty cells and some spaces between cells. How can I replace the empty cells with NA and remove extra spaces? Thank you very much!

Here is what my file looks like: my data

I have a csv file that has 7 columns. It has empty cells and some spaces between cells. How can I replace the empty cells with NA and remove extra spaces? Thank you very much!

Here is what my file looks like:

130070078,PPW0001,1,4,4HW ,2,15.61943874 120040039,PPW0002,0,0, ,0,0 120040043,PPW0003,1,3,3WE ,1,14.43394935 110030030,PPW0004,1,2,2L2M2 ,2,13.75770021 110030032,PPW0005,1,2,2L2M2 ,1,13.70568104 110030033,PPW0006,1,2,2L2M2 ,2,12.56399726 110030037,PPW0007,1,2,2L2M2 ,2,14.22313484 120050053,PPW0008,0,0, ,0,0 120050054,PPW0009,1,3,3WE ,2,16.06297057