reading data from csv files in python

Question

I am trying to extract data from a dummy csv file to use inside tensorflow. The dummy data only has 2 columns: X (single feature column) and Y (expected output).

X     Y 
11.0 13.0
23.0 33.3 
...  ...  and so on

Right now I am reading the data like so:

import pandas as pd

dummy_data = pd.read_csv("dummy_data.csv", sep=",")
inputX = dummy_data.loc[:, 'X'].values
np.reshape(inputX, [11, 1])

I am reshaping the numpy array because I need to do matrix multiplication later on with linear regression but I want to ask is that the correct way to extract a column from csv data? Is there a better way to directly extract the csv data to a tensor object?

DYZ · Accepted Answer · 2017-08-21 07:28:23Z

1

There is no need to reshape or use .loc or .values:

inputX = dummy_data[['X']]

(Mind the list of lists [[]]!)

answered Aug 21, 2017 at 7:28

DYZ

57.3k10 gold badges73 silver badges101 bronze badges

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

Collectives™ on Stack Overflow

reading data from csv files in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related