https://daewonyoon.tistory.com/383
파이썬 xlrd.biffh.XLRDError: Excel xlsx file; not supported
파이썬으로 엑셀파일을 다루는 코드가 아래와 같은 에러메시지를 발생하며 돌아가지 않았다. 에러메시지로 구글링을 하여보니 xlrd 패키지 (엑셀파일 읽기에 사용되는 패키지) 가 이제는 xls 파
daewonyoon.tistory.com
https://blog.naver.com/PostView.nhn?blogId=rising_n_falling&logNo=221622971970
Pandas - DataFrame에서 특정 행, 열 선택
안녕하세요. '라이징n폴링'입니다. 이번 글에서는 Python의 데이터 구조 중 하나인 DataFrame...
blog.naver.com
https://stackoverflow.com/questions/22089317/export-from-pandas-to-excel-without-row-names-index
Export from pandas to_excel without row names (index)?
I'm trying to print out a dataframe from pandas into Excel. Here I am using to_excel() functions. However, I found that the 1st column in Excel is the "index", 0 6/6/2021 0:00 8/6/2021 0:00 1...
stackoverflow.com
https://re-thought.com/how-to-change-or-update-a-cell-value-in-python-pandas-dataframe/
How to change or update a specific cell in Python Pandas Dataframe
Accessing a single value or updating the value of single row is sometime needed in Python Pandas Dataframe when we don't want to create a new Dataframe for just updating that single cell value. The easiest way to to access a single cell values is via Panda
re-thought.com
#-*-coding:utf-8-*-
import pandas as pd
import openpyxl
from openpyxl import load_workbook
import shutil
origin = 'test.xlsx'
res = origin.split('.')
new = res[0]+"_new."+res[1]
shutil.copy(origin,new)
data = pd.read_excel(new, engine='openpyxl')
field_info = data.columns
row_len = len(data)
print(data.at[0,field_info[0]])
for i in range(len(data)):
if pd.isnull(data.loc[i][0]) == False :
tmp = data.loc[i][0]
print(tmp)
else :
data.at[i,field_info[0]] = tmp
print(data)
print("-------------")
writer = pd.ExcelWriter("final.xlsx", engine='xlsxwriter')
data.to_excel(writer, index=False)
writer.save()
'일상 > 기타' 카테고리의 다른 글
| [앱리뷰] 기프티콘 판매 어플 니콘내콘 사용법 (판매/정산) (0) | 2020.06.07 |
|---|