-1

I'm trying to read in a text file with two columns, in numpy/pandas.

I get an error on both columns, Member_ID, Home_ownership, however, after adding delimiter=',', the issue disappears for Home_ownership column.

Here's my code. Based on online videos I tried adding encoder='latin', but it didn't work.

import numpy as np
import matplotlib.pyplot as plt 
import pandas as pd

home_ownership = np.loadtxt(r'C:\Users\Shlesha13\Desktop\mais-202-coding-challenge-f2019-master\home_ownership_data.csv', delimiter=',')
print (home_ownership)
smci
  • 29,564
  • 18
  • 109
  • 144
Shlesha Van
  • 1
  • 1
    Please provide a traceback. – pppery Sep 13 '19 at 01:37
  • whats the csv file look like..whats in it – Derek Eden Sep 13 '19 at 01:37
  • Hey, here is the link to csv file: https://drive.google.com/file/d/1TLoze56FhyQoIMkC6Pvz9m-AsVe5cbX_/view?usp=sharing – Shlesha Van Sep 13 '19 at 01:55
  • Welcome to SO. Please be sure to state your issue clearly ("reading in a text (CSV) file with two columns"); also to tag clearly (this should have been tagged 'pandas' and has nothing to do with Spyder, Spyder is only the IDE, it doesn't cause errors) – smci Sep 16 '19 at 20:16

1 Answers1

2

You can read your CSV using numpy or using pandas.

import numpy as np
# import matplotlib.pyplot as plt 
import pandas as pd

path = 'home_ownership_data.csv'
arr = np.genfromtxt(path, delimiter=',', dtype=None)
df = pd.read_csv(path)
print(df)
print(arr)
Justin Ezequiel
  • 5,254
  • 2
  • 11
  • 14