CODEWITHSUNDEEP
pythonexcelexport-to-csv
Hendrra
Hendrra

Reputation: 859

Problems with creating a CSV file using Excel

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:

Small amount of data I would like to analyze

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:

The wrong output

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.

Upvotes: 0

Views: 112

Answers (1)

Piotrek
Piotrek

Reputation: 1530

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)

Upvotes: 1

Related Questions