Roadmap
The pynvl package is just warming up!
Here are the planned enhancements and future directions.
🔹 Core Functions
- Initial helpers:
nvl,decode,sign,noneif,nvl2 - Add more PL/SQL-inspired helpers:
extract_xml
🔹 Pandas Integration
pd_nvl(series, default)=> fillNaN/Nonewith defaultpd_decode(series, mapping, default)=> map values with fallbackpd_sign(series)=> vectorized numeric signpd_noneif(series)pd_nvl2(series)
🔹 Regex Helpers
regexp_like(string, pattern)=> boolean matchregexp_substr(string, pattern, occurrence=1)=> extract substringregexp_replace(string, pattern, replacement)=> regex substitutionregexp_instr(string, pattern)=> position of match
🔹 Testing & Quality
- Expand test coverage across all functions
- Cover edge cases (e.g.
None == Noneindecode)
🔹 Documentation
- Expand API docs with detailed examples
🔹 Longer-Term Ideas
- Performance optimizations for large data sets
🔹 Contributions
New ideas are welcome! See CONTRIBUTING.md for guidelines.