How can I load a .dat file (that is comma separated) in python?

Question

I am trying to load a data file that is two columns of data, separated by a comma using: Data = np.loadtxt('real3kHz.dat'), where real3kHz.dat is the name of the file with the following data:

4998.29641,-0.00003
4997.33205,-0.00005
4996.36768,-0.00007
4995.40332,-0.00008
4994.43895,-0.00008
4993.47459,-0.00008
4992.51023,-0.00006
4991.54586,-0.00006
4990.5815,-0.00005
4989.61714,-0.00006
 ....

However, I keep getting the following error:

ValueError: could not convert string to float: '4998.29641,-0.00003'

I presumed that I successfully changed the cvs file into a .dat file (by saving it as a .dat file in notepad) before loading it into python. Can I get some help understanding where I am going wrong? Thank you in advance

Can you edit to post a few lines from the .dat file? It sounds like it is CSV formatted. — Gino Mempin
– Gino Mempin, Commented Jan 21, 2021 at 23:58
Hello thank you for your response. I have edited the question to include some of the data. I did in fact load the cvs into notepad and saved it as .dat file before loading into python, I am not sure if that was sufficient — jojo
– jojo, Commented Jan 22, 2021 at 0:10
Does this answer your question? load csv into 2D matrix with numpy for plotting — mkrieger1
– mkrieger1, Commented Jan 22, 2021 at 0:49

bashBedlam · Accepted Answer · 2021-01-22 01:09:36Z

1

Try this and see if it's doing what your asking for :

with open ('real3kHz.dat') as data_file :
for line in data_file :
    line_list = line.strip ('\n').split (',')
    print (f'{float (line_list [0])}   {float (line_list [1]):.5f}')

answered Jan 22, 2021 at 1:09

bashBedlam

1,5101 gold badge10 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gino Mempin Over a year ago

Or use Python's csv module instead of parsing the lines manually.

Collectives™ on Stack Overflow

How can I load a .dat file (that is comma separated) in python?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related