Dataframe encoding

New to Julia
6

How do I call string on the date values?

simple workaround: try on the CSV reading part - reading as a String

  • orders = CSV.read( IOBuffer(csv) ; types=[Int64,Int64,Int64,String,Int64] )

My log ( Julia 1.1 )

julia> using CSV, DataFrames, SQLite
julia> csv = """OrderID,CustomersID,EmployeeID,Orderdate,ShipperID
       10248,90,5,1990-07-04,3
       10249,81,6,1996-07-05,1
       """
"OrderID,CustomersID,EmployeeID,Orderdate,ShipperID\n10248,90,5,1990-07-04,3\n10249,81,6,1996-07-05,1\n"
julia> orders = CSV.read( IOBuffer(csv) ; types=[Int64,Int64,Int64,String,Int64] )
2×5 DataFrame
│ Row │ OrderID │ CustomersID │ EmployeeID │ Orderdate  │ ShipperID │
│     │ Int64   │ Int64       │ Int64      │ String     │ Int64     │
├─────┼─────────┼─────────────┼────────────┼────────────┼───────────┤
│ 1   │ 10248   │ 90          │ 5          │ 1990-07-04 │ 3         │
│ 2   │ 10249   │ 81          │ 6          │ 1996-07-05 │ 1         │
julia> acme = SQLite.DB()
SQLite.DB(in-memory)
julia> SQLite.load!(orders, acme, "orders")
"orders"
julia> DataFrame(SQLite.Query(acme,"""select * from orders
                 where orderdate = '1996-07-05'
                 """))
1×5 DataFrame
│ Row │ OrderID │ CustomersID │ EmployeeID │ Orderdate  │ ShipperID │
│     │ Int64⍰  │ Int64⍰      │ Int64⍰     │ String⍰    │ Int64⍰    │
├─────┼─────────┼─────────────┼────────────┼────────────┼───────────┤
│ 1   │ 10249   │ 81          │ 6          │ 1996-07-05 │ 1         │

code:

using CSV, DataFrames, SQLite
csv = """OrderID,CustomersID,EmployeeID,Orderdate,ShipperID
10248,90,5,1990-07-04,3
10249,81,6,1996-07-05,1
"""
orders = CSV.read( IOBuffer(csv) ; types=[Int64,Int64,Int64,String,Int64] )
acme = SQLite.DB() 
SQLite.load!(orders, acme, "orders") 
DataFrame(SQLite.Query(acme,"""select * from orders
          where orderdate = '1996-07-05'
          """))
1 Like