Problems with creating a CSV file using Excel

Question

I have some data in an Excel file. I would like to analyze them using Python. I started by creating a CSV file using this guide.

Thus I have created a CSV (Comma delimited) file filled with the following data:

I wrote a few lines of code in Python using Spyder:

import pandas
colnames = ['GDP', 'Unemployment', 'CPI', 'HousePricing']
data = pandas.read_csv('Dane_2.csv', names = colnames)
GDP = data.GDP.tolist()
print(GDP)

The output is nothing I've expected:

It can be easily seen that the output differs a lot from the figures in GDP column. I will appreciate any tips or hints which will help to deal with my problem.

Might be worth incuding the first few lines of your CSV as it appears in a text editor. — feedMe
– feedMe, Commented Sep 20, 2018 at 12:50
This is a common issue when you're working with European decimal notation. CSVs can be an problem unless you by default import/export using defined separators like the semicolon. So consider this going forward. — JamesR
– JamesR, Commented Sep 20, 2018 at 12:53

Piotrek · Accepted Answer · 2018-09-20 12:46:47Z

1

Seems like in the GDP column there are decimal values from the first column in the .csv file and first digits of the second column. There's either something wrong with the .csv you created, but more probably you need to specify separator in the pandas.read_csv line. Also, add header=None, to make sure you don't lose the first line of the file (i.e. it will get replaced by colnames).

Try this:

import pandas
colnames = ['GDP', 'Unemployment', 'CPI', 'HousePricing']
data = pandas.read_csv('Dane_2.csv', names = colnames, header=None, sep=';')
GDP = data.GDP.tolist()
print(GDP)

answered Sep 20, 2018 at 12:46

Piotrek

1,54012 silver badges18 bronze badges

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

2 Comments

Hendrra Over a year ago

Thank you! I think it worked. Is there an "easy" way to change strings into floats?

Piotrek Over a year ago

sure, use: data['column name'] = data['column name'].astype(float). Also, if it helped you, do you mind accepting the answer?

Collectives™ on Stack Overflow

Problems with creating a CSV file using Excel

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related