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)

• [x] Example data as provided in vignette and README
• [ ] DBIE data (need to test with multiple data)
• • [x] Few Examples as included in the package
• • [ ] Multiple data from DBIE https://github.com/r-rudra/tidycells/issues/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
  • • [x] enron [Part of test]
  • • [x] 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 https://github.com/r-rudra/tidycells/issues/6
• [ ] Example medntioned in unheadr
• [ ] Example mentioned in hypoparsr
• • [x] Demo mentioned here and in readme
• • [ ] Other test files here

[bedantaguru]

Add example given in https://github.com/nacnudus/unpivotr/issues/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/abs@.nsf/DetailsPage/5206.0Sep%202019?OpenDocument

However, there are many tables having similar types as given in {tidyABS}. Example : https://www.abs.gov.au/AUSSTATS/abs@.nsf/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!)