[python][openpyxl-04] 행, 열 삭제, 병합 해제, 셀의 정보를 여러 행으로 분할
Synopsis
행 열 삭제, 병합, 병합 해제 방법을 알아보고, 한 개의 셀에 여러 개의 정보가 있을 때 나누어 여러 행으로 만드는 실습을 포함합니다.
You Might Also Like
![[PYTHON] Splitting(Exploding) a column into multiple rows | 하나의 열을 여러 행으로 분할하기](https://i.ytimg.com/vi/ByJOO21qusI/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDBaFRkn1IzWz0tJQa9_4FfuQ3G6w)
![[시나공 컴활] 4207981 셀 삽입 삭제 병합](https://i.ytimg.com/vi/AnlZ6YaxwEU/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB_gmAAtAFigIMCAAQARhCIGUoOTAP&rs=AOn4CLDJUax1ZOb3N-z-bMNUo0np21jSXQ)
![[PYTHON-183] 파일의 열 조작 | 열 교환, 열 삭제](https://i.ytimg.com/vi/x3X9MBpvass/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLD3QkSLrgmHVPdBVEFb9A1hI6rCfg)
![[PYTHON-182] 파일의 행 조작 연습 | 행삭제, 행삽입, 행단위 변경](https://i.ytimg.com/vi/1XAoIgNB1U8/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLASlWadBUdlsHQ6n-3cSqFkz2LadQ)
![[엑셀] 여러 셀의 데이터를 한 셀로 합치기-1 / Combine data from multiple cells into one cell in Excel-1](https://i.ytimg.com/vi/nEJLgmGkv2M/hq720_2.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGABwAcABBvABAfgBtgiAAoAPigIMCAAQARgTIE8ofzAP&rs=AOn4CLCbAnJBoyHIVJ21fvRbNVE41DMjGA)
![[PYTHON][openpyxl-06, pandas 맛보기] 행/열을 제거하는 작업을 pandas로 해결하기](https://i.ytimg.com/vi/SG3gUUfzi1w/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBoYWLVjZpe11bJK6z7fp_i-Ad1Rw)
Download Options
Choose a download method below. All links open in new tabs.
| Service | Features | Action |
|---|---|---|
| Ssvid |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
| SaveFrom |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.