I have a .dat-file which I want to read with python and I need to extract one column with measurement values from the .dat-file.
I would like to assign, for example, a variable -> a=column 1 of the .dat file
Can someone help me?
Dear Thalita Emanuelle Nazaré ,
Use this function to read your .dat file:
import csv
# read flash.dat to a list of lists
datContent = [i.strip().split() for i in open("./flash.dat").readlines()]
# write it as a new CSV file
with open("./Your_File.csv", "wb") as f: writer = csv.writer(f) writer.writerows(datContent)
# Csv Reader
def read_csv(self,File_Name):
self.file_Name = File_Name
file = open(self.file_Name +".csv", "r")
reader = csv.reader(file)
self.data_read = [row for row in reader]
file.close()
self.data = ()
for i in range(len(self.data_read)):
self.data = self.data + ((int(self.data_read[i][0]), float(self.data_read[i][1]), float(self.data_read[i][2]),......, float(self.data_read[i][n])),)
return(self.data)
import numpy as np
column_x=np.loadtext('file.dat')
If your data are numbers, the file should load as a matrix.
I do not know types of your data. But you can search numpy and loadtext words.
You can find different approach in this link: https://stackoverflow.com/questions/29328420/read-specific-column-from-dat-file-in-python
You can also use pandas:
import pandas as pd df = pd.read_csv('*.dat', header=None, sep=',', engine='python') # you can use appropriate separator in sep="" saved_column = df.column_name #you can also use df['column_name']
- Badges
- Science topic
- Similar topics
- Phytochemistry
- Extracts