I have imported a CSV file in python using the pandas library, but what is returned isn't a list or table (I got the format below), so when I try to get a column values, using the name of the header, I got en error.. how can I deal with this problem?
a;b;c
0 9;4;1
1 8;3;99
2 6;5;100
Hello dear Fatiha;
for reading a CSV file, call pd.read_csv(file_name, usecols=cols_list) with file_name as the name of the CSV file, delimiter as the delimiter, and cols_list as the list of specific columns to read from the CSV file. Call df[col] with df as the DataFrame from the previous step, and col as the column name to read. I hope you find it helpful.
Regards;
Fatemeh
After you have your data imported in data frame format you can use SQL to tease out the information you want. I use "sqldf" Link here: https://pypi.org/project/sqldf/
Hello, as CSV means "comma separated value", so try to change the separator in excel to "," instead of ";".
data = pd.read_csv('panda_csv.csv', skipinitialspace=True)
# You are checking the keys / header of each column
print(data.keys())
# It will print the column having head 'a'
print(data['a'])
you can also try to add sep="," or sep=";" while reading the data.
Thank you.
- Badges
- Science topic
- Similar topics
- Computer Science and Engineering
- Programming Languages
- Python