Comments (6)
针对问题一:
目前我是使用xlrd做的excel中的读取,他没法很好地区分是否是合并单元格。不知道您有什么建议,可以更好地实现这个功能?
from dapy.
针对问题二:
sheet.show显示错位的问题主要是中英文的字符长度不同,目前我是在用英文长度计算的,之后我会尝试尽快修复该问题,谢谢您的建议!
from dapy.
针对问题一:
目前我是使用xlrd做的excel中的读取,他没法很好地区分是否是合并单元格。不知道您有什么建议,可以更好地实现这个功能?
这个处理是没问题的,但是第2列是否不应该是一个空字符串,而是“_1”,第3列才是“_2”
from dapy.
我在进行自动命名表头的时候,是先进行尽可能保留原始给的字符串。那么在第二列中,由于他给的字符串就是个空字符串,所以我没有进行修改,则第二列的表头为空。再识别第三列的时候,由于发现空字符串命名的列已经存在,所以会在该列的后面自动添加一个_1。在检索到第四列的时候,发现又出现了空字符串,并且_1已经出现过了,所以会自动变为_2。
from dapy.
提一个思路,例如A1-C1是合并单元格,值是A,是否可以将其重命名为A, A_1, A_2。
现在我觉得可能是没有必要的,搞复杂化了
from dapy.
我的设计思路是这样的,每一列有且仅有一个列标题。我们使用合并单元格的时候一般都会在下一行,会有一个更为细致的列名。比如,合并单元格的内容为“支出”,她底下可能有三个列分别为“食品”、“娱乐”和“生活用品”之类的。所以我的下一步想法是生成:"支出_视频”、“支出_娱乐"、”支出_生活用品“这样的列名。
from dapy.
Related Issues (14)
- Typo in CountFrequancy HOT 1
- Latest DaPy fails to load pageranker HOT 6
- 读取个excel再输出为sqlite3时,excel的第一行读取不出来,输出失败。 HOT 1
- UnicodeDecodeError: 'gbk' codec can't decode byte 0xae in position 48: illegal multibyte sequence HOT 4
- time.clock()的问题 HOT 1
- AssertionError:Sn is not a title in current dataset HOT 1
- No module named 'multiprocess'
- Code formatting in README HOT 4
- Please upload the test csv? HOT 3
- A typo in the Instruction part HOT 1
- 写库支持postgre不? HOT 1
- dp.read() 的 first_line 参数好像没有实现 HOT 4
- pip 版本Dapy-1.10.10 无法对 Sheet 进行 print HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dapy.