CODEWITHSUNDEEP
python-3.xpandascsv
Andy Garcia
Andy Garcia

Reputation: 79

How do I remove first column in csv file?

I have a CSV file where the first row in the first column is blank with some numbers in the second and third row. This whole column is useless and I need to remove it so I can convert the data into a JSON file. I just need to know how to remove the first column of data so I can parse it. Any help is greatly appreciated!

My script is as follows 

#!/usr/bin/python3

import pandas as pd
import csv, json

xls = pd.ExcelFile(r'C:\Users\Andy-\Desktop\Lab2Data.xlsx')
df = xls.parse(sheetname="Sheet1", index_col=None, na_values=['NA'])
df.to_csv('file.csv')

file = open('file.csv', 'r')
lines = file.readlines()
file.close()

data = {}

with open('file.csv') as csvFile:
    csvReader = csv.DictReader(csvFile)
    for rows in csvReader:
        id = rows['Id']
        data[id] = rows

with open('Lab2.json', 'w') as jsonFile:
    jsonFile.write(json.dumps(data, indent=4))

Upvotes: 0

Views: 1706

Answers (1)

bashBedlam
bashBedlam

Reputation: 1500

I don't know much about json files but this will remove the first column from your csv file.

with open ('new_file.csv', 'w') as out_file :
    with open ('file.csv') as in_file :
        for line in in_file :
            test_string = line.strip ('\n').split (',')
            out_file.write (','.join (test_string [1:]) + '\n')

Upvotes: 2

Related Questions