Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

セル結合 #17

Open
Rindrics opened this issue May 15, 2019 · 3 comments
Open

セル結合 #17

Rindrics opened this issue May 15, 2019 · 3 comments

Comments

@Rindrics
Copy link
Owner

No description provided.

@Rindrics
Copy link
Owner Author

Rindrics commented Jul 5, 2019

農林統計の左下,右上のセル結合を解除した状態.
黄色セルには値が入っていないため,このまま検索をかけると情報が抜け落ちる(例えば「その他の漁業」の行や「こんぶ類」「その他の海藻類」の列はなくなる).
image

@Rindrics
Copy link
Owner Author

Rindrics commented Jul 5, 2019

行列を並べ替えて,tidyr::fill() に任せることも思いついたが,無理そう.
理由は,必ずセル結合されているとは限らないから.
image

@Rindrics
Copy link
Owner Author

Rindrics commented Jul 5, 2019

このセル結合のブレはものすごく極悪.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant