pandas to_csv 最后一位 出现科学计数0

切换别的思路

从mysql导出csv时，是在后面加\t来避免 科学计数法 显示问题
pandas 处理后发现尾数数值一致变为0，这就是很大的麻烦了呀

# -*- coding: utf-8 -*-
import os
import json
import datacompy
import numpy as np
import pandas as pd
from hashlib import md5
from decimal import *
import nmap3
import json
import random
from concurrent.futures import ThreadPoolExecutor, as_completed
import numpy as np


name = '文档名称'
file_path = '文档路径' + '\\' + name 
writer = pd.ExcelWriter(name+".xlsx", engine='xlsxwriter', options={'strings_to_urls':False}) 
df = pd.read_csv(file_path +".csv",,encoding="ANSI",converters={'编号':str}) # ANSI gbk dtype=str,  converters={'编号':str}
df['编号'] = df['编号'].apply(lambda x: str(x).replace('\t','')+'', 1)
df.to_excel(writer,index = False)
writer.save()