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

Preserve valid identifiers in SQL-DF import #3

Open
snunez1 opened this issue Sep 26, 2023 · 0 comments
Open

Preserve valid identifiers in SQL-DF import #3

snunez1 opened this issue Sep 26, 2023 · 0 comments
Labels
enhancement New feature or request

Comments

@snunez1
Copy link

snunez1 commented Sep 26, 2023

Discussed in Lisp-Stat/lisp-stat#24

Originally posted by gassechen September 27, 2023
Hello, I have a question.
If I use pprint to print the data frame these are the results

(pprint df2)
;; ESN       ASSET_ID          
;; 0-4513034   672061 
;; 2-3211115   609473 

but if I use them with sqldf they are these

(pprint (sqldf:sqldf  "select esn,ASSET_ID from DF2 limit 10"))
;; ESN       ASSET-ID
;; 0-4513034   672061
;; 2-3211115   609473

It is changing the names of the keys
ASSET_ID --> ASSET-ID

SQL-DF permanently modifies identifiers into idiomatic lisp format, even those that are valid lisp identifiers, but non-idiomatic. This should be configurable.

@snunez1 snunez1 transferred this issue from Lisp-Stat/lisp-stat Sep 26, 2023
@snunez1 snunez1 added the enhancement New feature or request label Sep 26, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant