Convert hex addresses .xlsx file to csv int using python

Question

Given a .xlsx file i want to convert it to .csv with the following format using Python

Given hex addresses .xlsx :

0xbfb22b18
0xbfb22b14
0xbfb22b10
0xbfb22b0c
0xbfb22b18
0xbfb22b14
0xbfb22b10
0xbfb22b0c

I need to convert to int .scv and add at the first line row the word "train_data"

The only relative I found is using panda , but I don't know how I can add the "train_data" .

S.j. Sakib · Accepted Answer · 2020-02-04 10:38:56Z

0

How about

data = open('tmp.xlsx', 'r').read()

numbers = map(lambda x: str(int(x, 16)), data.split())

content = 'train_data\n' + '\n'.join(numbers) + '\n'

with open('tmp.csv', 'w') as f:
    f.write(content)

answered Feb 4, 2020 at 10:38

S.j. Sakib

4661 gold badge5 silver badges19 bronze badges

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

Comments

Zaraki Kenpachi · Accepted Answer · 2020-02-04 10:53:54Z

0

Here You go:

import pandas as pd

df = pd.read_excel('data.xlsx', index_col=None, names=['train_data'])
df['train_data'] = df['train_data'].apply(lambda x: int(x, 16))
df.to_csv('data.csv', index=False)

answered Feb 4, 2020 at 10:53

Zaraki Kenpachi

5,7802 gold badges17 silver badges40 bronze badges

Collectives™ on Stack Overflow

Convert hex addresses .xlsx file to csv int using python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related