Extract data from a csv file

Question

I have data like this form:

X=[]; 
X=[X,0.114]; 
X=[X,0.749]; 
X=[X,0.358]; 
    .
    .
    .

I want to extract the values in the lists in a single list, as:

X = [0.114, 0.749, 0.358,...]

I used this code but it doesn't work:

import pandas as pd
data = pd.read_csv('Xtest.txt')
count = data['X']

Could you please help me pull the values? And thank you.

How is X=[X,0.114]; X=[X,0.749]; X=[X,0.358]; CSV format?

Code Pope
– Code Pope

2020-05-03 14:59:05 +00:00
Commented May 3, 2020 at 14:59 — Code Pope
– Code Pope, Commented May 3, 2020 at 14:59

E_K · Accepted Answer · 2020-05-03 15:11:57Z

2

How about plain python? Something like

X = []
with open('Xtest.txt', 'r') as file:
    lines = file.readlines()
    for line in lines:
        try:
            X.append(float(line.split(',')[1].split(']')[0]))
        except Exception:
            continue
print(X)

answered May 3, 2020 at 15:11

E_K

2,24929 silver badges47 bronze badges

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

2 Comments

walid Over a year ago

It returns a blank list [ ]. Actually I edited my question, I think that my data is not sorted as CSV file, it is just a .txt file where the data are in that form.

E_K Over a year ago

I made an edit to my answer kindly try Again. I replaced X.append(int(line.split(',')[1].split(']')[0])) with X.append(float(line.split(',')[1].split(']')[0]))

Dreamer12 · Accepted Answer · 2020-05-03 15:05:52Z

0

If 0.114, 0.749, 0.358,..are the values in column1 of the CSV file, the answer is as follows,

import pandas as pd
data = pd.read_csv('Xtest.txt')
y = data[0].to_list()
print(y)

answered May 3, 2020 at 15:05

Dreamer12

286 bronze badges

1 Comment

walid Over a year ago

It doesn't work. Sorry, I edited my question, I think that my data is not sorted as CSV file, it is just a .txt file where the data are in that form.

Collectives™ on Stack Overflow

Extract data from a csv file

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related