Define a column from a csv as "Y"

Asked Oct 24 '19 at 19:53

Active Oct 24 '19 at 19:53

Viewed 60 times

How to define a column from a csv file as a Letter. For example, I want to name the second and the third column, respectively, as X and Y.

I have an CSV file where the values are separated by ";". The columns have 68 rows and the first row/header is the name of the column. I would like to name the second and the third column, respectively, as X and Y. Using pandas i've tried

import pandas as pd
dataset = pd.read_csv(r'C:\Users\t1079577\Desktop\DATABASE.csv', sep=";")
x='com_proc'
y='result_op'

It doesent read the entire column.

asked Oct 24 '19 at 19:53

viniwata1

I didn't express myself well enough. I would like to call the entire column (values included) to use them, as if it was a vector with 68 coordinates – viniwata1 Oct 24 '19 at 19:59
1

`x = df['column_name'].values.tolist()` will do what you want. However, this is a poor way to use a dataframe. – Trenton McKinney Oct 24 '19 at 20:00
It worked! Thank you – viniwata1 Oct 24 '19 at 20:07
Possible duplicate of [get list from pandas dataframe column](https://stackoverflow.com/questions/22341271/get-list-from-pandas-dataframe-column) – Trenton McKinney Oct 24 '19 at 20:09

Define a column from a csv as "Y"

0 Answers0