Python Pandas, Export string columns into Excel file

user_12990701 0
Viewed 444

I am working with codes from dataframe column, example: case_id=211246842501 When I export to excel file show me something like this case_id= 2112+17 Even if I convert the value into string:

EUROC= pd.read_excel(f'{NewFilePath}{NewFile}', sheet_name="EUROC")   
EUROC['case_id']=EUROC['case_id'].values.astype(str)
FileFinal='Test Prueba.xlsx'
full_path_file = f'{ICSPath}{FileFinal}'
writer = pd.ExcelWriter(full_path_file, engine='xlsxwriter', )
EUROC.to_excel(writer, sheet_name='EUROC', index=False)

What I can do to show the hole number? It can be string value I don't have issues with that but I need that the real value show us in the excel.

enter image description here

Regards

pandas excel python
1 Answers

could not test the program as sample data not available but objective to see full case_id can be accomplished theoritically with following

EUROC= pd.read_excel(f'{NewFilePath}{NewFile}', sheet_name="EUROC")   
EUROC['case_id']=EUROC['case_id'].values.astype(str)
EUROC['case_id'] = EUROC.apply(lambda x: "'" + str(x.case_id) , axis = 1)  #added line
FileFinal='Test Prueba.xlsx'
full_path_file = f'{ICSPath}{FileFinal}'
writer = pd.ExcelWriter(full_path_file, engine='xlsxwriter', )
EUROC.to_excel(writer, sheet_name='EUROC', index=False)
user_86571830
Related