Create Example Data on which read_cells works (as expected)

[bedantaguru]

The algorithm currently working on certain types of data. Definitely, It is yet not rendering the expected output on several well-known data. Add support for those.

As of now supported. (CRAN V0.2.1)

• Example data as provided in vignette and README
• DBIE data (need to test with multiple data)
• • Few Examples as included in the package
• • Multiple data from DBIE Test Supported Example Data from DBIE #3
• ABS Data
• • Should work on examples given in tidyABS
• • Explore further ABS data
• Examples in unpivotr and related packages (or works)
• • Examples in inst
  • • enron [Part of test]
  • • purpose [More complex version in package]. Need to check for raw file.
  • • Other files.
• • "Worked examples on GitHub." by Duncan Garmonsway
• • smungs examples [examples given in Spreadsheet Munging Strategies by Duncan Garmonsway]
• Examples and datasets cited in jailbreakr
• • EUSES corpus (related paper)
• • Spreadsheets at Enron (Ref 2)
• • Explore OpenRefine Link and Relate with other Big Projects #6
• Example medntioned in unheadr
• Example mentioned in hypoparsr
• • Demo mentioned here and in readme
• • Other test files here

[bedantaguru]

Add example given in nacnudus/unpivotr#31 also mentioned here

However, it will never be possible to directly support this type of data. Rather create/try the ways to solve it.

[bedantaguru]

https://github.com/ianmoran11/tidyABS#example-3-consumer-price-index-time-series seems supported.

[bedantaguru]

Many economic indicators in ABS has been migrated to SDMX ready structures.
Example :
https://www.abs.gov.au/AUSSTATS/[email protected]/DetailsPage/5206.0Sep%202019?OpenDocument

However, there are many tables having similar types as given in {tidyABS}.
Example :
https://www.abs.gov.au/AUSSTATS/[email protected]/DetailsPage/6224.0.55.001June%202019?OpenDocument

[bedantaguru]

Just checked

unpivotr\inst\extdata\worked-examples.xlsx@pivot-centre-aligned:G8 -->
the cell can not be mapped correctly. This is because line separator plays a major role here.
Maybe some method need to deploy to tweak the automatic understanding.

[bedantaguru]

Following is similar to ABS datasets.

unpivotr\inst\extdata\worked-examples.xlsx@pivot-hierarchy

[bedantaguru]

These [somehow] works
However, may need to place heuristic for uniform block patterns.
unpivotr\inst\extdata\worked-examples.xlsx@

• pivot-repeated-headers
• pivot-header-within-data
• notes
• transposed
• pivot-annotations

These are not working properly

• small-multiples (mainly for corner join cases)
• implied-multiples (don't know why few of them getting emptied. Need to check!)