Package evaluation of Query on Julia 1.11.4 (a71dd056e0*) started at 2025-04-08T10:16:17.540 ################################################################################ # Set-up # Installing PkgEval dependencies (TestEnv)... Set-up completed after 8.4s ################################################################################ # Installation # Installing Query... Resolving package versions... Updating `~/.julia/environments/v1.11/Project.toml` [1a8c2f83] + Query v1.0.0 Updating `~/.julia/environments/v1.11/Manifest.toml` [34da2185] + Compat v4.16.0 [9a962f9c] + DataAPI v1.16.0 [864edb3b] + DataStructures v0.18.22 [e2d170a0] + DataValueInterfaces v1.0.0 [e7dc6d0d] + DataValues v0.4.13 [1c8ee90f] + IterableTables v1.0.0 [82899510] + IteratorInterfaceExtensions v1.0.0 [682c06a0] + JSON v0.21.4 [1914dd2f] + MacroTools v0.5.15 [e1d29d7a] + Missings v1.2.0 [bac558e1] + OrderedCollections v1.8.0 [69de0a69] + Parsers v2.8.1 ⌅ [aea7be01] + PrecompileTools v1.2.1 [21216c6a] + Preferences v1.4.3 [1a8c2f83] + Query v1.0.0 [2aef5ad7] + QueryOperators v0.9.3 [ae029012] + Requires v1.3.1 [10745b16] + Statistics v1.11.1 [5e66a065] + TableShowUtils v0.2.6 [3783bdb8] + TableTraits v1.0.1 [382cd787] + TableTraitsUtils v1.0.2 [56f22d72] + Artifacts v1.11.0 [2a0f44e3] + Base64 v1.11.0 [ade2ca70] + Dates v1.11.0 [b77e0a4c] + InteractiveUtils v1.11.0 [8f399da3] + Libdl v1.11.0 [37e2e46d] + LinearAlgebra v1.11.0 [d6f4376e] + Markdown v1.11.0 [a63ad114] + Mmap v1.11.0 [de0858da] + Printf v1.11.0 [9a3f8284] + Random v1.11.0 [ea8e919c] + SHA v0.7.0 [fa267f1f] + TOML v1.0.3 [cf7118a7] + UUIDs v1.11.0 [4ec0a83e] + Unicode v1.11.0 [e66e0078] + CompilerSupportLibraries_jll v1.1.1+0 [4536629a] + OpenBLAS_jll v0.3.27+1 [8e850b90] + libblastrampoline_jll v5.11.0+0 Info Packages marked with ⌅ have new versions available but compatibility constraints restrict them from upgrading. To see why use `status --outdated -m` Installation completed after 1.7s ################################################################################ # Precompilation # Precompiling PkgEval dependencies... Precompiling package dependencies... Precompilation completed after 33.48s ################################################################################ # Testing # Testing Query Status `/tmp/jl_sU9vKF/Project.toml` [a93c6f00] DataFrames v1.7.0 [e7dc6d0d] DataValues v0.4.13 [e30172f5] Documenter v1.10.1 [6deec6e2] IndexedTables v1.0.1 [1c8ee90f] IterableTables v1.0.0 [1914dd2f] MacroTools v0.5.15 [1a8c2f83] Query v1.0.0 [2aef5ad7] QueryOperators v0.9.3 [10745b16] Statistics v1.11.1 [9d95f2ec] TypedTables v1.4.6 [ade2ca70] Dates v1.11.0 [8dfed614] Test v1.11.0 Status `/tmp/jl_sU9vKF/Manifest.toml` [a4c015fc] ANSIColoredPrinters v0.0.1 [1520ce14] AbstractTrees v0.4.5 ⌅ [79e6a3ab] Adapt v2.4.0 [66dad0bd] AliasTables v1.1.3 [944b1d66] CodecZlib v0.7.8 [34da2185] Compat v4.16.0 [a8cc5b0e] Crayons v4.1.1 [9a962f9c] DataAPI v1.16.0 [a93c6f00] DataFrames v1.7.0 [864edb3b] DataStructures v0.18.22 [e2d170a0] DataValueInterfaces v1.0.0 [e7dc6d0d] DataValues v0.4.13 [85a47980] Dictionaries v0.4.5 [ffbed154] DocStringExtensions v0.9.4 [e30172f5] Documenter v1.10.1 [d7ba0133] Git v1.3.1 [b5f81e59] IOCapture v0.2.5 [6deec6e2] IndexedTables v1.0.1 [313cdc1a] Indexing v1.1.1 [842dd82b] InlineStrings v1.4.3 [41ab1584] InvertedIndices v1.3.1 [92d709cd] IrrationalConstants v0.2.4 [1c8ee90f] IterableTables v1.0.0 [82899510] IteratorInterfaceExtensions v1.0.0 [692b3bcd] JLLWrappers v1.7.0 [682c06a0] JSON v0.21.4 [b964fa9f] LaTeXStrings v1.4.0 [0e77f7df] LazilyInitializedFields v1.3.0 [2ab3a3ac] LogExpFunctions v0.3.29 [1914dd2f] MacroTools v0.5.15 [d0879d2d] MarkdownAST v0.1.2 [e1d29d7a] Missings v1.2.0 [925886fa] OnlineStatsBase v1.7.1 [bac558e1] OrderedCollections v1.8.0 [69de0a69] Parsers v2.8.1 [2dfb63ee] PooledArrays v1.4.3 ⌅ [aea7be01] PrecompileTools v1.2.1 [21216c6a] Preferences v1.4.3 [08abe8d2] PrettyTables v2.4.0 [43287f4e] PtrArrays v1.3.0 [1a8c2f83] Query v1.0.0 [2aef5ad7] QueryOperators v0.9.3 [189a3867] Reexport v1.2.2 [2792f1a3] RegistryInstances v0.1.0 [ae029012] Requires v1.3.1 [91c51154] SentinelArrays v1.4.8 [a2af1166] SortingAlgorithms v1.2.1 [03a91e81] SplitApplyCombine v1.2.3 [10745b16] Statistics v1.11.1 [82ae8749] StatsAPI v1.7.0 [2913bbd2] StatsBase v0.34.4 [892a3eda] StringManipulation v0.4.1 ⌅ [09ab397b] StructArrays v0.4.4 [5e66a065] TableShowUtils v0.2.6 [3783bdb8] TableTraits v1.0.1 [382cd787] TableTraitsUtils v1.0.2 [bd369af6] Tables v1.12.0 [3bb67fe8] TranscodingStreams v0.11.3 [9d95f2ec] TypedTables v1.4.6 [ea10d353] WeakRefStrings v1.4.2 [2e619515] Expat_jll v2.6.5+0 [f8c6e375] Git_jll v2.49.0+0 [94ce4f54] Libiconv_jll v1.18.0+0 [458c3c95] OpenSSL_jll v3.0.16+0 [0dad84c5] ArgTools v1.1.2 [56f22d72] Artifacts v1.11.0 [2a0f44e3] Base64 v1.11.0 [ade2ca70] Dates v1.11.0 [8ba89e20] Distributed v1.11.0 [f43a241f] Downloads v1.6.0 [7b1f6079] FileWatching v1.11.0 [9fa8497b] Future v1.11.0 [b77e0a4c] InteractiveUtils v1.11.0 [b27032c2] LibCURL v0.6.4 [76f85450] LibGit2 v1.11.0 [8f399da3] Libdl v1.11.0 [37e2e46d] LinearAlgebra v1.11.0 [56ddb016] Logging v1.11.0 [d6f4376e] Markdown v1.11.0 [a63ad114] Mmap v1.11.0 [ca575930] NetworkOptions v1.2.0 [44cfe95a] Pkg v1.11.0 [de0858da] Printf v1.11.0 [3fa0cd96] REPL v1.11.0 [9a3f8284] Random v1.11.0 [ea8e919c] SHA v0.7.0 [9e88b42a] Serialization v1.11.0 [6462fe0b] Sockets v1.11.0 [2f01184e] SparseArrays v1.11.0 [f489334b] StyledStrings v1.11.0 [fa267f1f] TOML v1.0.3 [a4e569a6] Tar v1.10.0 [8dfed614] Test v1.11.0 [cf7118a7] UUIDs v1.11.0 [4ec0a83e] Unicode v1.11.0 [e66e0078] CompilerSupportLibraries_jll v1.1.1+0 [deac9b47] LibCURL_jll v8.6.0+0 [e37daf67] LibGit2_jll v1.7.2+0 [29816b5a] LibSSH2_jll v1.11.0+1 [c8ffd9c3] MbedTLS_jll v2.28.6+0 [14a3606d] MozillaCACerts_jll v2023.12.12 [4536629a] OpenBLAS_jll v0.3.27+1 [efcefdf7] PCRE2_jll v10.42.0+1 [bea87d4a] SuiteSparse_jll v7.7.0+0 [83775a58] Zlib_jll v1.2.13+1 [8e850b90] libblastrampoline_jll v5.11.0+0 [8e850ede] nghttp2_jll v1.59.0+0 [3f19e933] p7zip_jll v17.4.0+2 Info Packages marked with ⌅ have new versions available but compatibility constraints restrict them from upgrading. Testing Running tests... ┌ Warning: Unable to determine HTML(edit_link = ...) from remote HEAD branch, defaulting to "master". │ Calling `git remote` failed with an exception. Set JULIA_DEBUG=Documenter to see the error. │ Unless this is due to a configuration error, the relevant variable should be set explicitly. └ @ Documenter ~/.julia/packages/Documenter/tbj1p/src/utilities/utilities.jl:660 [ Info: SetupBuildDirectory: setting up build directory. [ Info: Doctest: running doctests. ┌ Error: doctest failure in ../docs/src/gettingstarted.md:9-28 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = df |> │ @filter(_.age>50) |> │ @map({_.name, _.children}) |> │ DataFrame │ │ println(x) │ │ # output │ │ 1×2 DataFrame │ │ Row │ name │ children │ │ │ │ String │ Int64 │ │ ├─────┼────────┼──────────┤ │ │ 1 │ Kirk │ 2 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = df |> │ @filter(_.age>50) |> │ @map({_.name, _.children}) |> │ DataFrame │ │ println(x) │ │ Evaluated output: │ │ 1×2 DataFrame │ Row │ name children │ │ String Int64 │ ─────┼────────────────── │ 1 │ Kirk 2 │ │ Expected output: │ │ 1×2 DataFrame │ │ Row │ name │ children │ │ │ │ String │ Int64 │ │ ├─────┼────────┼──────────┤ │ │ 1 │ Kirk │ 2 │ │ │ diff = │ Warning: Diff output requires color. │ 1×2 DataFrame │ │ DataFrame │ Row │ name │ children │ │ │ │ String │ Int64 │ │ ├─────┼────────┼──────────┤ │ │ 1 name children │ │ Kirk String Int64 │ ─────┼────────────────── │ 1 │ 2 │Kirk 2 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/gettingstarted.md:9 ┌ Error: doctest failure in ../docs/src/gettingstarted.md:45-65 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @where i.age>50 │ @select {i.name, i.children} │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 1×2 DataFrame │ │ Row │ name │ children │ │ │ │ String │ Int64 │ │ ├─────┼────────┼──────────┤ │ │ 1 │ Kirk │ 2 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @where i.age>50 │ @select {i.name, i.children} │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 1×2 DataFrame │ Row │ name children │ │ String Int64 │ ─────┼────────────────── │ 1 │ Kirk 2 │ │ Expected output: │ │ 1×2 DataFrame │ │ Row │ name │ children │ │ │ │ String │ Int64 │ │ ├─────┼────────┼──────────┤ │ │ 1 │ Kirk │ 2 │ │ │ diff = │ Warning: Diff output requires color. │ 1×2 DataFrame │ │ DataFrame │ Row │ name │ children │ │ │ │ String │ Int64 │ │ ├─────┼────────┼──────────┤ │ │ 1 name children │ │ Kirk String Int64 │ ─────┼────────────────── │ 1 │ 2 │Kirk 2 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/gettingstarted.md:45 ┌ Error: doctest failure in ../docs/src/sinks.md:34-55 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @select {i.name, i.age, Children=i.children} │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 3×3 DataFrame │ │ Row │ name │ age │ Children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ John │ 23.0 │ 3 │ │ │ 2 │ Sally │ 42.0 │ 5 │ │ │ 3 │ Kirk │ 59.0 │ 2 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @select {i.name, i.age, Children=i.children} │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 3×3 DataFrame │ Row │ name age Children │ │ String Float64 Int64 │ ─────┼─────────────────────────── │ 1 │ John 23.0 3 │ 2 │ Sally 42.0 5 │ 3 │ Kirk 59.0 2 │ │ Expected output: │ │ 3×3 DataFrame │ │ Row │ name │ age │ Children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ John │ 23.0 │ 3 │ │ │ 2 │ Sally │ 42.0 │ 5 │ │ │ 3 │ Kirk │ 59.0 │ 2 │ │ │ diff = │ Warning: Diff output requires color. │ 3×3 DataFrame │ │ DataFrame │ Row │ name │ age │ Children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ John │ 23.0 │ 3 │ │ │ 2 │ Sally │ 42.0 │ 5 │ │ name age Children │ │ 3 String Float64 Int64 │ ─────┼─────────────────────────── │ 1 │ Kirk John 23.0 3 │ 2 │ 59.0 Sally 42.0 5 │ 3 │ 2 │Kirk 59.0 2 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/sinks.md:34 ┌ Error: doctest failure in ../docs/src/sinks.md:63-78 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @select i.name=>i.children │ @collect Dict │ end │ │ println(x) │ │ # output │ │ Dict("Sally" => 5,"John" => 3,"Kirk" => 2) │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @select i.name=>i.children │ @collect Dict │ end │ │ println(x) │ │ Evaluated output: │ │ Dict("Sally" => 5, "John" => 3, "Kirk" => 2) │ │ Expected output: │ │ Dict("Sally" => 5,"John" => 3,"Kirk" => 2) │ │ diff = │ Warning: Diff output requires color. │ Dict("Sally" => 5,"John" 5, "John" => 3,"Kirk" 3, "Kirk" => 2) └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/sinks.md:63 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:9-34 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(a=[2,1,1,2,1,3],b=[2,2,1,1,3,2]) │ │ x = @from i in df begin │ @orderby descending(i.a), i.b │ @select i │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 6×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 2 │ │ │ 2 │ 2 │ 1 │ │ │ 3 │ 2 │ 2 │ │ │ 4 │ 1 │ 1 │ │ │ 5 │ 1 │ 2 │ │ │ 6 │ 1 │ 3 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(a=[2,1,1,2,1,3],b=[2,2,1,1,3,2]) │ │ x = @from i in df begin │ @orderby descending(i.a), i.b │ @select i │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 6×2 DataFrame │ Row │ a b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 3 2 │ 2 │ 2 1 │ 3 │ 2 2 │ 4 │ 1 1 │ 5 │ 1 2 │ 6 │ 1 3 │ │ Expected output: │ │ 6×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 2 │ │ │ 2 │ 2 │ 1 │ │ │ 3 │ 2 │ 2 │ │ │ 4 │ 1 │ 1 │ │ │ 5 │ 1 │ 2 │ │ │ 6 │ 1 │ 3 │ │ │ diff = │ Warning: Diff output requires color. │ 6×2 DataFrame │ │ DataFrame │ Row │ a a b │ │ b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 2 │ │ │ 2 │ 2 │ 1 │ │ │ 3 │ 2 │ 2 │ │ │ 4 │ 1 │ 1 │ │ │ 5 │ 1 │ 2 │ │ │ 6 │ 1 │ 3 │3 2 │ 2 │ 2 1 │ 3 │ 2 2 │ 4 │ 1 1 │ 5 │ 1 2 │ 6 │ 1 3 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:9 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:42-62 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @where i.age > 30. && i.children > 2 │ @select i │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 1×3 DataFrame │ │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ Sally │ 42.0 │ 5 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @where i.age > 30. && i.children > 2 │ @select i │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 1×3 DataFrame │ Row │ name age children │ │ String Float64 Int64 │ ─────┼─────────────────────────── │ 1 │ Sally 42.0 5 │ │ Expected output: │ │ 1×3 DataFrame │ │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ Sally │ 42.0 │ 5 │ │ │ diff = │ Warning: Diff output requires color. │ 1×3 DataFrame │ │ DataFrame │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ Sally name age children │ │ 42.0 String Float64 Int64 │ ─────┼─────────────────────────── │ 1 │ 5 │Sally 42.0 5 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:42 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:90-111 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @select {i.name, Age=i.age} │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 3×2 DataFrame │ │ Row │ name │ Age │ │ │ │ String │ Float64 │ │ ├─────┼────────┼─────────┤ │ │ 1 │ John │ 23.0 │ │ │ 2 │ Sally │ 42.0 │ │ │ 3 │ Kirk │ 59.0 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @select {i.name, Age=i.age} │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 3×2 DataFrame │ Row │ name Age │ │ String Float64 │ ─────┼───────────────── │ 1 │ John 23.0 │ 2 │ Sally 42.0 │ 3 │ Kirk 59.0 │ │ Expected output: │ │ 3×2 DataFrame │ │ Row │ name │ Age │ │ │ │ String │ Float64 │ │ ├─────┼────────┼─────────┤ │ │ 1 │ John │ 23.0 │ │ │ 2 │ Sally │ 42.0 │ │ │ 3 │ Kirk │ 59.0 │ │ │ diff = │ Warning: Diff output requires color. │ 3×2 DataFrame │ │ DataFrame │ Row │ name │ Age │ │ │ │ String │ Float64 │ │ ├─────┼────────┼─────────┤ │ │ 1 │ John │ 23.0 │ │ │ 2 │ Sally name Age │ │ 42.0 │ │ String Float64 │ ─────┼───────────────── │ 1 │ 3 John 23.0 │ 2 │ Kirk Sally 42.0 │ 3 │ 59.0 │Kirk 59.0 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:90 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:121-145 │ │ ```jldoctest │ using DataFrames, Query │ │ source = Dict(:a=>[1,2,3], :b=>[4,5]) │ │ q = @from i in source begin │ @from j in i.second │ @select {Key=i.first,Value=j} │ @collect DataFrame │ end │ │ println(q) │ │ # output │ │ 5×2 DataFrame │ │ Row │ Key │ Value │ │ │ │ Symbol │ Int64 │ │ ├─────┼────────┼───────┤ │ │ 1 │ a │ 1 │ │ │ 2 │ a │ 2 │ │ │ 3 │ a │ 3 │ │ │ 4 │ b │ 4 │ │ │ 5 │ b │ 5 │ │ ``` │ │ Subexpression: │ │ using DataFrames, Query │ │ source = Dict(:a=>[1,2,3], :b=>[4,5]) │ │ q = @from i in source begin │ @from j in i.second │ @select {Key=i.first,Value=j} │ @collect DataFrame │ end │ │ println(q) │ │ Evaluated output: │ │ 5×2 DataFrame │ Row │ Key Value │ │ Symbol Int64 │ ─────┼─────────────── │ 1 │ a 1 │ 2 │ a 2 │ 3 │ a 3 │ 4 │ b 4 │ 5 │ b 5 │ │ Expected output: │ │ 5×2 DataFrame │ │ Row │ Key │ Value │ │ │ │ Symbol │ Int64 │ │ ├─────┼────────┼───────┤ │ │ 1 │ a │ 1 │ │ │ 2 │ a │ 2 │ │ │ 3 │ a │ 3 │ │ │ 4 │ b │ 4 │ │ │ 5 │ b │ 5 │ │ │ diff = │ Warning: Diff output requires color. │ 5×2 DataFrame │ │ DataFrame │ Row │ Key │ Value │ │ │ │ Symbol │ Int64 │ │ ├─────┼────────┼───────┤ │ │ 1 │ a │ 1 │ │ │ 2 │ a │ 2 │ │ │ 3 │ a │ 3 │ │ Key Value │ │ 4 Symbol Int64 │ ─────┼─────────────── │ 1 │ b a 1 │ 2 │ 4 │ │ a 2 │ 3 │ 5 a 3 │ 4 │ b b 4 │ 5 │ 5 │b 5 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:121 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:157-179 │ │ ```jldoctest │ using DataFrames, Query │ │ df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) │ df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"]) │ │ x = @from i in df1 begin │ @join j in df2 on i.a equals j.c │ @select {i.a,i.b,j.c,j.d} │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 2×4 DataFrame │ │ Row │ a │ b │ c │ d │ │ │ │ Int64 │ Float64 │ Int64 │ String │ │ ├─────┼───────┼─────────┼───────┼────────┤ │ │ 1 │ 2 │ 2.0 │ 2 │ John │ │ │ 2 │ 2 │ 2.0 │ 2 │ Sally │ │ ``` │ │ Subexpression: │ │ using DataFrames, Query │ │ df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) │ df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"]) │ │ x = @from i in df1 begin │ @join j in df2 on i.a equals j.c │ @select {i.a,i.b,j.c,j.d} │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 2×4 DataFrame │ Row │ a b c d │ │ Int64 Float64 Int64 String │ ─────┼─────────────────────────────── │ 1 │ 2 2.0 2 John │ 2 │ 2 2.0 2 Sally │ │ Expected output: │ │ 2×4 DataFrame │ │ Row │ a │ b │ c │ d │ │ │ │ Int64 │ Float64 │ Int64 │ String │ │ ├─────┼───────┼─────────┼───────┼────────┤ │ │ 1 │ 2 │ 2.0 │ 2 │ John │ │ │ 2 │ 2 │ 2.0 │ 2 │ Sally │ │ │ diff = │ Warning: Diff output requires color. │ 2×4 DataFrame │ │ DataFrame │ Row │ a │ b │ c a b c d │ │ d │ │ Int64 Float64 Int64 String │ ─────┼─────────────────────────────── │ 1 │ │ Int64 │ Float64 │ Int64 │ String │ │ ├─────┼───────┼─────────┼───────┼────────┤ │ │ 1 │ 2 │ 2.0 │ 2 │ John │ │ │ 2 │ 2 │ 2.0 │ 2 │ Sally │2 2.0 2 John │ 2 │ 2 2.0 2 Sally └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:157 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:187-210 │ │ ```jldoctest │ using DataFrames, Query │ │ df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) │ df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"]) │ │ x = @from i in df1 begin │ @join j in df2 on i.a equals j.c into k │ @select {t1=i.a,t2=length(k)} │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 3×2 DataFrame │ │ Row │ t1 │ t2 │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 0 │ │ │ 2 │ 2 │ 2 │ │ │ 3 │ 3 │ 0 │ │ ``` │ │ Subexpression: │ │ using DataFrames, Query │ │ df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) │ df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"]) │ │ x = @from i in df1 begin │ @join j in df2 on i.a equals j.c into k │ @select {t1=i.a,t2=length(k)} │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 3×2 DataFrame │ Row │ t1 t2 │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 1 0 │ 2 │ 2 2 │ 3 │ 3 0 │ │ Expected output: │ │ 3×2 DataFrame │ │ Row │ t1 │ t2 │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 0 │ │ │ 2 │ 2 │ 2 │ │ │ 3 │ 3 │ 0 │ │ │ diff = │ Warning: Diff output requires color. │ 3×2 DataFrame │ │ DataFrame │ Row │ t1 t1 t2 │ │ t2 │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 0 │ │ │ 2 │ 2 │ 2 │ │ │ 3 │ 3 │ 0 │1 0 │ 2 │ 2 2 │ 3 │ 3 0 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:187 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:218-242 │ │ ```jldoctest │ using Query, DataFrames │ │ source_df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) │ source_df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"]) │ │ q = @from i in source_df1 begin │ @left_outer_join j in source_df2 on i.a equals j.c │ @select {i.a,i.b,j.c,j.d} │ @collect DataFrame │ end │ │ println(q) │ │ # output │ │ 4×4 DataFrame │ │ Row │ a │ b │ c │ d │ │ │ │ Int64 │ Float64 │ Int64⍰ │ String⍰ │ │ ├─────┼───────┼─────────┼─────────┼─────────┤ │ │ 1 │ 1 │ 1.0 │ missing │ missing │ │ │ 2 │ 2 │ 2.0 │ 2 │ John │ │ │ 3 │ 2 │ 2.0 │ 2 │ Sally │ │ │ 4 │ 3 │ 3.0 │ missing │ missing │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ source_df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) │ source_df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"]) │ │ q = @from i in source_df1 begin │ @left_outer_join j in source_df2 on i.a equals j.c │ @select {i.a,i.b,j.c,j.d} │ @collect DataFrame │ end │ │ println(q) │ │ Evaluated output: │ │ 4×4 DataFrame │ Row │ a b c d │ │ Int64 Float64 Int64? String? │ ─────┼────────────────────────────────── │ 1 │ 1 1.0 missing missing │ 2 │ 2 2.0 2 John │ 3 │ 2 2.0 2 Sally │ 4 │ 3 3.0 missing missing │ │ Expected output: │ │ 4×4 DataFrame │ │ Row │ a │ b │ c │ d │ │ │ │ Int64 │ Float64 │ Int64⍰ │ String⍰ │ │ ├─────┼───────┼─────────┼─────────┼─────────┤ │ │ 1 │ 1 │ 1.0 │ missing │ missing │ │ │ 2 │ 2 │ 2.0 │ 2 │ John │ │ │ 3 │ 2 │ 2.0 │ 2 │ Sally │ │ │ 4 │ 3 │ 3.0 │ missing │ missing │ │ │ diff = │ Warning: Diff output requires color. │ 4×4 DataFrame │ │ DataFrame │ Row │ a │ b │ c a b c d │ │ d │ │ Int64 Float64 Int64? String? │ ─────┼────────────────────────────────── │ 1 │ │ Int64 │ Float64 │ Int64⍰ │ String⍰ │ │ ├─────┼───────┼─────────┼─────────┼─────────┤ │ │ 1 │ 1 │ 1.0 │ missing │ missing │ │ │ 2 │ 2 │ 2.0 │ 2 │ John │ │ │ 3 │ 2 │ 2.0 │ 2 │ Sally │ │ │ 4 │ 3 │ 3.0 │ missing │ missing │1 1.0 missing missing │ 2 │ 2 2.0 2 John │ 3 │ 2 2.0 2 Sally │ 4 │ 3 3.0 missing missing └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:218 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:252-267 │ │ ```jldoctest │ using DataFrames, Query │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,2,2]) │ │ x = @from i in df begin │ @group i.name by i.children │ @collect │ end │ │ println(x) │ │ # output │ │ Grouping{Int64,String}[["John"], ["Sally", "Kirk"]] │ ``` │ │ Subexpression: │ │ using DataFrames, Query │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,2,2]) │ │ x = @from i in df begin │ @group i.name by i.children │ @collect │ end │ │ println(x) │ │ Evaluated output: │ │ Grouping{Int64, String}[["John"], ["Sally", "Kirk"]] │ │ Expected output: │ │ Grouping{Int64,String}[["John"], ["Sally", "Kirk"]] │ │ diff = │ Warning: Diff output requires color. │ Grouping{Int64,String}[["John"], Grouping{Int64, String}[["John"], ["Sally", "Kirk"]] └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:252 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:271-292 │ │ ```jldoctest │ using DataFrames, Query │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,2,2]) │ │ x = @from i in df begin │ @group i by i.children into g │ @select {Key=key(g),Count=length(g)} │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 2×2 DataFrame │ │ Row │ Key │ Count │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 1 │ │ │ 2 │ 2 │ 2 │ │ ``` │ │ Subexpression: │ │ using DataFrames, Query │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,2,2]) │ │ x = @from i in df begin │ @group i by i.children into g │ @select {Key=key(g),Count=length(g)} │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 2×2 DataFrame │ Row │ Key Count │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 3 1 │ 2 │ 2 2 │ │ Expected output: │ │ 2×2 DataFrame │ │ Row │ Key │ Count │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 1 │ │ │ 2 │ 2 │ 2 │ │ │ diff = │ Warning: Diff output requires color. │ 2×2 DataFrame │ │ DataFrame │ Row │ Key Key Count │ │ Count │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 1 │ │ │ 2 │ 2 │ 2 │3 1 │ 2 │ 2 2 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:271 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:300-323 │ │ ```jldoctest │ using Query, DataFrames, Statistics │ │ df = DataFrame(name=repeat(["John", "Sally", "Kirk"],inner=[1],outer=[2]), │ age=vcat([10., 20., 30.],[10., 20., 30.].+3), │ children=repeat([3,2,2],inner=[1],outer=[2]),state=[:a,:a,:a,:b,:b,:b]) │ │ x = @from i in df begin │ @group i by i.state into g │ @select {group=key(g),mage=mean(g.age), oldest=maximum(g.age), youngest=minimum(g.age)} │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 2×4 DataFrame │ │ Row │ group │ mage │ oldest │ youngest │ │ │ │ Symbol │ Float64 │ Float64 │ Float64 │ │ ├─────┼────────┼─────────┼─────────┼──────────┤ │ │ 1 │ a │ 20.0 │ 30.0 │ 10.0 │ │ │ 2 │ b │ 23.0 │ 33.0 │ 13.0 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames, Statistics │ │ df = DataFrame(name=repeat(["John", "Sally", "Kirk"],inner=[1],outer=[2]), │ age=vcat([10., 20., 30.],[10., 20., 30.].+3), │ children=repeat([3,2,2],inner=[1],outer=[2]),state=[:a,:a,:a,:b,:b,:b]) │ │ x = @from i in df begin │ @group i by i.state into g │ @select {group=key(g),mage=mean(g.age), oldest=maximum(g.age), youngest=minimum(g.age)} │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 2×4 DataFrame │ Row │ group mage oldest youngest │ │ Symbol Float64 Float64 Float64 │ ─────┼──────────────────────────────────── │ 1 │ a 20.0 30.0 10.0 │ 2 │ b 23.0 33.0 13.0 │ │ Expected output: │ │ 2×4 DataFrame │ │ Row │ group │ mage │ oldest │ youngest │ │ │ │ Symbol │ Float64 │ Float64 │ Float64 │ │ ├─────┼────────┼─────────┼─────────┼──────────┤ │ │ 1 │ a │ 20.0 │ 30.0 │ 10.0 │ │ │ 2 │ b │ 23.0 │ 33.0 │ 13.0 │ │ │ diff = │ Warning: Diff output requires color. │ 2×4 DataFrame │ │ DataFrame │ Row │ group │ mage │ oldest │ youngest │ │ │ │ Symbol │ Float64 │ Float64 group mage oldest youngest │ │ Symbol Float64 │ │ ├─────┼────────┼─────────┼─────────┼──────────┤ │ │ 1 │ a │ 20.0 │ 30.0 │ 10.0 │ │ │ 2 │ b │ 23.0 Float64 Float64 │ ─────┼──────────────────────────────────── │ 1 │ 33.0 a 20.0 30.0 10.0 │ 2 │ 13.0 │b 23.0 33.0 13.0 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:300 ┌ Error: doctest failure in ../docs/src/linqquerycommands.md:331-353 │ │ ```jldoctest │ using DataFrames, Query │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,2,2]) │ │ x = @from i in df begin │ @let count = length(i.name) │ @let kids_per_year = i.children / i.age │ @where count > 4 │ @select {Name=i.name, Count=count, KidsPerYear=kids_per_year} │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 1×3 DataFrame │ │ Row │ Name │ Count │ KidsPerYear │ │ │ │ String │ Int64 │ Float64 │ │ ├─────┼────────┼───────┼─────────────┤ │ │ 1 │ Sally │ 5 │ 0.047619 │ │ ``` │ │ Subexpression: │ │ using DataFrames, Query │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,2,2]) │ │ x = @from i in df begin │ @let count = length(i.name) │ @let kids_per_year = i.children / i.age │ @where count > 4 │ @select {Name=i.name, Count=count, KidsPerYear=kids_per_year} │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 1×3 DataFrame │ Row │ Name Count KidsPerYear │ │ String Int64 Float64 │ ─────┼──────────────────────────── │ 1 │ Sally 5 0.047619 │ │ Expected output: │ │ 1×3 DataFrame │ │ Row │ Name │ Count │ KidsPerYear │ │ │ │ String │ Int64 │ Float64 │ │ ├─────┼────────┼───────┼─────────────┤ │ │ 1 │ Sally │ 5 │ 0.047619 │ │ │ diff = │ Warning: Diff output requires color. │ 1×3 DataFrame │ │ DataFrame │ Row │ Name │ Count │ KidsPerYear │ │ │ │ String │ Int64 │ Float64 │ │ ├─────┼────────┼───────┼─────────────┤ │ │ 1 Name Count KidsPerYear │ │ Sally String Int64 Float64 │ ─────┼──────────────────────────── │ 1 │ Sally 5 │ 0.047619 │0.047619 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/linqquerycommands.md:331 ┌ Error: doctest failure in ../docs/src/sources.md:11-32 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @select i │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 3×3 DataFrame │ │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ John │ 23.0 │ 3 │ │ │ 2 │ Sally │ 42.0 │ 5 │ │ │ 3 │ Kirk │ 59.0 │ 2 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in df begin │ @select i │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ 3×3 DataFrame │ Row │ name age children │ │ String Float64 Int64 │ ─────┼─────────────────────────── │ 1 │ John 23.0 3 │ 2 │ Sally 42.0 5 │ 3 │ Kirk 59.0 2 │ │ Expected output: │ │ 3×3 DataFrame │ │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ John │ 23.0 │ 3 │ │ │ 2 │ Sally │ 42.0 │ 5 │ │ │ 3 │ Kirk │ 59.0 │ 2 │ │ │ diff = │ Warning: Diff output requires color. │ 3×3 DataFrame │ │ DataFrame │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ John │ 23.0 │ 3 │ │ │ 2 │ Sally │ 42.0 │ 5 │ │ name age children │ │ 3 String Float64 Int64 │ ─────┼─────────────────────────── │ 1 │ Kirk John 23.0 3 │ 2 │ 59.0 Sally 42.0 5 │ 3 │ 2 │Kirk 59.0 2 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/sources.md:11 ┌ Error: doctest failure in ../docs/src/sources.md:40-61 │ │ ```jldoctest │ using Query, DataFrames, TypedTables │ │ tt = Table(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in tt begin │ @select i │ @collect DataFrame │ end │ │ println(x) │ │ # output │ │ 3×3 DataFrame │ │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ John │ 23.0 │ 3 │ │ │ 2 │ Sally │ 42.0 │ 5 │ │ │ 3 │ Kirk │ 59.0 │ 2 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames, TypedTables │ │ tt = Table(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = @from i in tt begin │ @select i │ @collect DataFrame │ end │ │ println(x) │ │ Evaluated output: │ │ Precompiling TypedTables... │ 1636.5 ms ✓ TypedTables │ 1 dependency successfully precompiled in 2 seconds. 12 already precompiled. │ 3×3 DataFrame │ Row │ name age children │ │ String Float64 Int64 │ ─────┼─────────────────────────── │ 1 │ John 23.0 3 │ 2 │ Sally 42.0 5 │ 3 │ Kirk 59.0 2 │ │ Expected output: │ │ 3×3 DataFrame │ │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ John │ 23.0 │ 3 │ │ │ 2 │ Sally │ 42.0 │ 5 │ │ │ 3 │ Kirk │ 59.0 │ 2 │ │ │ diff = │ Warning: Diff output requires color. │ Precompiling TypedTables... │ 1636.5 ms ✓ TypedTables │ 1 dependency successfully precompiled in 2 seconds. 12 already precompiled. │ 3×3 DataFrame │ │ DataFrame │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ John │ 23.0 │ 3 │ │ │ 2 │ Sally │ 42.0 │ 5 │ │ name age children │ │ 3 String Float64 Int64 │ ─────┼─────────────────────────── │ 1 │ Kirk John 23.0 3 │ 2 │ 59.0 Sally 42.0 5 │ 3 │ 2 │Kirk 59.0 2 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/sources.md:40 ┌ Error: doctest failure in ../docs/src/sources.md:69-92 │ │ ```jldoctest │ using Query, DataFrames │ │ struct Person │ Name::String │ Friends::Vector{String} │ end │ │ source = [ │ Person("John", ["Sally", "Miles", "Frank"]), │ Person("Sally", ["Don", "Martin"])] │ │ result = @from i in source begin │ @where length(i.Friends) > 2 │ @select {i.Name, Friendcount=length(i.Friends)} │ @collect │ end │ │ println(result) │ │ # output │ │ NamedTuple{(:Name, :Friendcount),Tuple{String,Int64}}[(Name = "John", Friendcount = 3)] │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ struct Person │ Name::String │ Friends::Vector{String} │ end │ │ source = [ │ Person("John", ["Sally", "Miles", "Frank"]), │ Person("Sally", ["Don", "Martin"])] │ │ result = @from i in source begin │ @where length(i.Friends) > 2 │ @select {i.Name, Friendcount=length(i.Friends)} │ @collect │ end │ │ println(result) │ │ Evaluated output: │ │ @NamedTuple{Name::String, Friendcount::Int64}[(Name = "John", Friendcount = 3)] │ │ Expected output: │ │ NamedTuple{(:Name, :Friendcount),Tuple{String,Int64}}[(Name = "John", Friendcount = 3)] │ │ diff = │ Warning: Diff output requires color. │ NamedTuple{(:Name, :Friendcount),Tuple{String,Int64}}[(Name @NamedTuple{Name::String, Friendcount::Int64}[(Name = "John", Friendcount = 3)] └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/sources.md:69 ┌ Error: doctest failure in ../docs/src/sources.md:100-115 │ │ ```jldoctest │ using Query, IndexedTables, Dates │ │ source_indexedtable = table((city=[fill("New York",3); fill("Boston",3)], date=repeat(Date(2016,7,6):Day(1):Date(2016,7,8), 2), value=[91,89,91,95,83,76])) │ q = @from i in source_indexedtable begin │ @where i.city=="New York" │ @select i.value │ @collect │ end │ │ println(q) │ │ # output │ │ [91, 89, 91] │ ``` │ │ Subexpression: │ │ using Query, IndexedTables, Dates │ │ source_indexedtable = table((city=[fill("New York",3); fill("Boston",3)], date=repeat(Date(2016,7,6):Day(1):Date(2016,7,8), 2), value=[91,89,91,95,83,76])) │ q = @from i in source_indexedtable begin │ @where i.city=="New York" │ @select i.value │ @collect │ end │ │ println(q) │ │ Evaluated output: │ │ Precompiling IndexedTables... │ 2387.8 ms ✓ StructArrays │ 4807.8 ms ✓ StatsBase │ 2828.2 ms ✓ OnlineStatsBase │ 7918.0 ms ✓ IndexedTables │ 4 dependencies successfully precompiled in 18 seconds. 44 already precompiled. │ [91, 89, 91] │ │ Expected output: │ │ [91, 89, 91] │ │ diff = │ Warning: Diff output requires color. │ Precompiling IndexedTables... │ 2387.8 ms ✓ StructArrays │ 4807.8 ms ✓ StatsBase │ 2828.2 ms ✓ OnlineStatsBase │ 7918.0 ms ✓ IndexedTables │ 4 dependencies successfully precompiled in 18 seconds. 44 already precompiled. │ [91, 89, 91] └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/sources.md:100 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:6-26 │ │ ```jldoctest │ using Query, DataFrames, Statistics │ │ df = DataFrame(a=[1,1,2,3], b=[4,5,6,8]) │ │ df2 = df |> │ @groupby(_.a) |> │ @map({a=key(_), b=mean(_.b)}) |> │ @filter(_.b > 5) |> │ @orderby_descending(_.b) |> │ DataFrame │ │ # output │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Float64 │ │ ├─────┼───────┼─────────┤ │ │ 1 │ 3 │ 8.0 │ │ │ 2 │ 2 │ 6.0 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames, Statistics │ │ df = DataFrame(a=[1,1,2,3], b=[4,5,6,8]) │ │ df2 = df |> │ @groupby(_.a) |> │ @map({a=key(_), b=mean(_.b)}) |> │ @filter(_.b > 5) |> │ @orderby_descending(_.b) |> │ DataFrame │ │ Evaluated output: │ │ 2×2 DataFrame │ Row │ a b │ │ Int64 Float64 │ ─────┼──────────────── │ 1 │ 3 8.0 │ 2 │ 2 6.0 │ │ Expected output: │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Float64 │ │ ├─────┼───────┼─────────┤ │ │ 1 │ 3 │ 8.0 │ │ │ 2 │ 2 │ 6.0 │ │ │ diff = │ Warning: Diff output requires color. │ 2×2 DataFrame │ │ DataFrame │ Row │ a a b │ │ b │ │ Int64 Float64 │ ─────┼──────────────── │ 1 │ │ Int64 │ Float64 │ │ ├─────┼───────┼─────────┤ │ │ 1 │ 3 │ 8.0 │ │ │ 2 │ 2 │ 6.0 │3 8.0 │ 2 │ 2 6.0 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:6 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:57-73 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = df |> @filter(_.age > 30 && _.children > 2) |> DataFrame │ │ println(x) │ │ # output │ │ 1×3 DataFrame │ │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ Sally │ 42.0 │ 5 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,5,2]) │ │ x = df |> @filter(_.age > 30 && _.children > 2) |> DataFrame │ │ println(x) │ │ Evaluated output: │ │ 1×3 DataFrame │ Row │ name age children │ │ String Float64 Int64 │ ─────┼─────────────────────────── │ 1 │ Sally 42.0 5 │ │ Expected output: │ │ 1×3 DataFrame │ │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ Sally │ 42.0 │ 5 │ │ │ diff = │ Warning: Diff output requires color. │ 1×3 DataFrame │ │ DataFrame │ Row │ name │ age │ children │ │ │ │ String │ Float64 │ Int64 │ │ ├─────┼────────┼─────────┼──────────┤ │ │ 1 │ Sally name age children │ │ 42.0 String Float64 Int64 │ ─────┼─────────────────────────── │ 1 │ 5 │Sally 42.0 5 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:57 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:85-105 │ │ ```jldoctest │ using DataFrames, Query │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,2,2]) │ │ x = df |> │ @groupby(_.children) |> │ @map({Key=key(_), Count=length(_)}) |> │ DataFrame │ │ println(x) │ │ # output │ │ 2×2 DataFrame │ │ Row │ Key │ Count │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 1 │ │ │ 2 │ 2 │ 2 │ │ ``` │ │ Subexpression: │ │ using DataFrames, Query │ │ df = DataFrame(name=["John", "Sally", "Kirk"], age=[23., 42., 59.], children=[3,2,2]) │ │ x = df |> │ @groupby(_.children) |> │ @map({Key=key(_), Count=length(_)}) |> │ DataFrame │ │ println(x) │ │ Evaluated output: │ │ 2×2 DataFrame │ Row │ Key Count │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 3 1 │ 2 │ 2 2 │ │ Expected output: │ │ 2×2 DataFrame │ │ Row │ Key │ Count │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 1 │ │ │ 2 │ 2 │ 2 │ │ │ diff = │ Warning: Diff output requires color. │ 2×2 DataFrame │ │ DataFrame │ Row │ Key Key Count │ │ Count │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 1 │ │ │ 2 │ 2 │ 2 │3 1 │ 2 │ 2 2 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:85 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:115-136 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(a=[2,1,1,2,1,3],b=[2,2,1,1,3,2]) │ │ x = df |> @orderby_descending(_.a) |> @thenby(_.b) |> DataFrame │ │ println(x) │ │ # output │ │ 6×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 2 │ │ │ 2 │ 2 │ 1 │ │ │ 3 │ 2 │ 2 │ │ │ 4 │ 1 │ 1 │ │ │ 5 │ 1 │ 2 │ │ │ 6 │ 1 │ 3 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(a=[2,1,1,2,1,3],b=[2,2,1,1,3,2]) │ │ x = df |> @orderby_descending(_.a) |> @thenby(_.b) |> DataFrame │ │ println(x) │ │ Evaluated output: │ │ 6×2 DataFrame │ Row │ a b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 3 2 │ 2 │ 2 1 │ 3 │ 2 2 │ 4 │ 1 1 │ 5 │ 1 2 │ 6 │ 1 3 │ │ Expected output: │ │ 6×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 2 │ │ │ 2 │ 2 │ 1 │ │ │ 3 │ 2 │ 2 │ │ │ 4 │ 1 │ 1 │ │ │ 5 │ 1 │ 2 │ │ │ 6 │ 1 │ 3 │ │ │ diff = │ Warning: Diff output requires color. │ 6×2 DataFrame │ │ DataFrame │ Row │ a a b │ │ b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 3 │ 2 │ │ │ 2 │ 2 │ 1 │ │ │ 3 │ 2 │ 2 │ │ │ 4 │ 1 │ 1 │ │ │ 5 │ 1 │ 2 │ │ │ 6 │ 1 │ 3 │3 2 │ 2 │ 2 1 │ 3 │ 2 2 │ 4 │ 1 1 │ 5 │ 1 2 │ 6 │ 1 3 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:115 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:144-163 │ │ ```jldoctest │ using DataFrames, Query │ │ df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) │ df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"]) │ │ x = df1 |> @groupjoin(df2, _.a, _.c, {t1=_.a, t2=length(__)}) |> DataFrame │ │ println(x) │ │ # output │ │ 3×2 DataFrame │ │ Row │ t1 │ t2 │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 0 │ │ │ 2 │ 2 │ 2 │ │ │ 3 │ 3 │ 0 │ │ ``` │ │ Subexpression: │ │ using DataFrames, Query │ │ df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) │ df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"]) │ │ x = df1 |> @groupjoin(df2, _.a, _.c, {t1=_.a, t2=length(__)}) |> DataFrame │ │ println(x) │ │ Evaluated output: │ │ 3×2 DataFrame │ Row │ t1 t2 │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 1 0 │ 2 │ 2 2 │ 3 │ 3 0 │ │ Expected output: │ │ 3×2 DataFrame │ │ Row │ t1 │ t2 │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 0 │ │ │ 2 │ 2 │ 2 │ │ │ 3 │ 3 │ 0 │ │ │ diff = │ Warning: Diff output requires color. │ 3×2 DataFrame │ │ DataFrame │ Row │ t1 t1 t2 │ │ t2 │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 0 │ │ │ 2 │ 2 │ 2 │ │ │ 3 │ 3 │ 0 │1 0 │ 2 │ 2 2 │ 3 │ 3 0 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:144 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:171-189 │ │ ```jldoctest │ using DataFrames, Query │ │ df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) │ df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"]) │ │ x = df1 |> @join(df2, _.a, _.c, {_.a, _.b, __.c, __.d}) |> DataFrame │ │ println(x) │ │ # output │ │ 2×4 DataFrame │ │ Row │ a │ b │ c │ d │ │ │ │ Int64 │ Float64 │ Int64 │ String │ │ ├─────┼───────┼─────────┼───────┼────────┤ │ │ 1 │ 2 │ 2.0 │ 2 │ John │ │ │ 2 │ 2 │ 2.0 │ 2 │ Sally │ │ ``` │ │ Subexpression: │ │ using DataFrames, Query │ │ df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) │ df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"]) │ │ x = df1 |> @join(df2, _.a, _.c, {_.a, _.b, __.c, __.d}) |> DataFrame │ │ println(x) │ │ Evaluated output: │ │ 2×4 DataFrame │ Row │ a b c d │ │ Int64 Float64 Int64 String │ ─────┼─────────────────────────────── │ 1 │ 2 2.0 2 John │ 2 │ 2 2.0 2 Sally │ │ Expected output: │ │ 2×4 DataFrame │ │ Row │ a │ b │ c │ d │ │ │ │ Int64 │ Float64 │ Int64 │ String │ │ ├─────┼───────┼─────────┼───────┼────────┤ │ │ 1 │ 2 │ 2.0 │ 2 │ John │ │ │ 2 │ 2 │ 2.0 │ 2 │ Sally │ │ │ diff = │ Warning: Diff output requires color. │ 2×4 DataFrame │ │ DataFrame │ Row │ a │ b │ c a b c d │ │ d │ │ Int64 Float64 Int64 String │ ─────┼─────────────────────────────── │ 1 │ │ Int64 │ Float64 │ Int64 │ String │ │ ├─────┼───────┼─────────┼───────┼────────┤ │ │ 1 │ 2 │ 2.0 │ 2 │ John │ │ │ 2 │ 2 │ 2.0 │ 2 │ Sally │2 2.0 2 John │ 2 │ 2 2.0 2 Sally └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:171 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:197-217 │ │ ```jldoctest │ using DataFrames, Query │ │ source = Dict(:a=>[1,2,3], :b=>[4,5]) │ │ q = source |> @mapmany(_.second, {Key=_.first, Value=__}) |> DataFrame │ │ println(q) │ │ # output │ │ 5×2 DataFrame │ │ Row │ Key │ Value │ │ │ │ Symbol │ Int64 │ │ ├─────┼────────┼───────┤ │ │ 1 │ a │ 1 │ │ │ 2 │ a │ 2 │ │ │ 3 │ a │ 3 │ │ │ 4 │ b │ 4 │ │ │ 5 │ b │ 5 │ │ ``` │ │ Subexpression: │ │ using DataFrames, Query │ │ source = Dict(:a=>[1,2,3], :b=>[4,5]) │ │ q = source |> @mapmany(_.second, {Key=_.first, Value=__}) |> DataFrame │ │ println(q) │ │ Evaluated output: │ │ 5×2 DataFrame │ Row │ Key Value │ │ Symbol Int64 │ ─────┼─────────────── │ 1 │ a 1 │ 2 │ a 2 │ 3 │ a 3 │ 4 │ b 4 │ 5 │ b 5 │ │ Expected output: │ │ 5×2 DataFrame │ │ Row │ Key │ Value │ │ │ │ Symbol │ Int64 │ │ ├─────┼────────┼───────┤ │ │ 1 │ a │ 1 │ │ │ 2 │ a │ 2 │ │ │ 3 │ a │ 3 │ │ │ 4 │ b │ 4 │ │ │ 5 │ b │ 5 │ │ │ diff = │ Warning: Diff output requires color. │ 5×2 DataFrame │ │ DataFrame │ Row │ Key │ Value │ │ │ │ Symbol │ Int64 │ │ ├─────┼────────┼───────┤ │ │ 1 │ a │ 1 │ │ │ 2 │ a │ 2 │ │ │ 3 │ a │ 3 │ │ Key Value │ │ 4 Symbol Int64 │ ─────┼─────────────── │ 1 │ b a 1 │ 2 │ 4 │ │ a 2 │ 3 │ 5 a 3 │ 4 │ b b 4 │ 5 │ 5 │b 5 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:197 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:283-301 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(fruit=["Apple","Banana","Cherry"],amount=[2,6,1000],price=[1.2,2.0,0.4],isyellow=[false,true,false]) │ │ q1 = df |> @select(2:3, occursin("ui"), -:amount) |> DataFrame │ │ println(q1) │ │ # output │ │ 3×2 DataFrame │ │ Row │ price │ fruit │ │ │ │ Float64 │ String │ │ ├─────┼─────────┼────────┤ │ │ 1 │ 1.2 │ Apple │ │ │ 2 │ 2.0 │ Banana │ │ │ 3 │ 0.4 │ Cherry │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(fruit=["Apple","Banana","Cherry"],amount=[2,6,1000],price=[1.2,2.0,0.4],isyellow=[false,true,false]) │ │ q1 = df |> @select(2:3, occursin("ui"), -:amount) |> DataFrame │ │ println(q1) │ │ Evaluated output: │ │ 3×2 DataFrame │ Row │ price fruit │ │ Float64 String │ ─────┼───────────────── │ 1 │ 1.2 Apple │ 2 │ 2.0 Banana │ 3 │ 0.4 Cherry │ │ Expected output: │ │ 3×2 DataFrame │ │ Row │ price │ fruit │ │ │ │ Float64 │ String │ │ ├─────┼─────────┼────────┤ │ │ 1 │ 1.2 │ Apple │ │ │ 2 │ 2.0 │ Banana │ │ │ 3 │ 0.4 │ Cherry │ │ │ diff = │ Warning: Diff output requires color. │ 3×2 DataFrame │ │ DataFrame │ Row │ price price fruit │ │ fruit │ │ Float64 String │ ─────┼───────────────── │ 1 │ │ Float64 │ String │ │ ├─────┼─────────┼────────┤ │ │ 1 │ 1.2 │ Apple │ │ │ 2 │ 2.0 │ Banana │ │ │ 3 │ 0.4 │ Cherry │1.2 Apple │ 2 │ 2.0 Banana │ 3 │ 0.4 Cherry └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:283 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:303-321 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(fruit=["Apple","Banana","Cherry"],amount=[2,6,1000],price=[1.2,2.0,0.4],isyellow=[false,true,false]) │ │ q2 = df |> @select(!endswith("t"), 1) |> DataFrame │ │ println(q2) │ │ # output │ │ 3×3 DataFrame │ │ Row │ price │ isyellow │ fruit │ │ │ │ Float64 │ Bool │ String │ │ ├─────┼─────────┼──────────┼────────┤ │ │ 1 │ 1.2 │ 0 │ Apple │ │ │ 2 │ 2.0 │ 1 │ Banana │ │ │ 3 │ 0.4 │ 0 │ Cherry │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(fruit=["Apple","Banana","Cherry"],amount=[2,6,1000],price=[1.2,2.0,0.4],isyellow=[false,true,false]) │ │ q2 = df |> @select(!endswith("t"), 1) |> DataFrame │ │ println(q2) │ │ Evaluated output: │ │ 3×3 DataFrame │ Row │ price isyellow fruit │ │ Float64 Bool String │ ─────┼─────────────────────────── │ 1 │ 1.2 false Apple │ 2 │ 2.0 true Banana │ 3 │ 0.4 false Cherry │ │ Expected output: │ │ 3×3 DataFrame │ │ Row │ price │ isyellow │ fruit │ │ │ │ Float64 │ Bool │ String │ │ ├─────┼─────────┼──────────┼────────┤ │ │ 1 │ 1.2 │ 0 │ Apple │ │ │ 2 │ 2.0 │ 1 │ Banana │ │ │ 3 │ 0.4 │ 0 │ Cherry │ │ │ diff = │ Warning: Diff output requires color. │ 3×3 DataFrame │ │ DataFrame │ Row │ price │ isyellow price isyellow fruit │ │ fruit │ │ Float64 Bool String │ ─────┼─────────────────────────── │ 1 │ │ Float64 │ Bool │ String │ │ ├─────┼─────────┼──────────┼────────┤ │ │ 1 │ 1.2 │ 0 │ Apple │ │ │ 2 │ 2.0 │ 1 │ Banana │ │ │ 3 │ false Apple │ 2 │ 2.0 true Banana │ 3 │ 0.4 │ 0 │ Cherry │false Cherry └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:303 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:327-345 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(fruit=["Apple","Banana","Cherry"],amount=[2,6,1000],price=[1.2,2.0,0.4],isyellow=[false,true,false]) │ │ q = df |> @rename(:fruit => :food, :price => :cost, :food => :name) |> DataFrame │ │ println(q) │ │ # output │ │ 3×4 DataFrame │ │ Row │ name │ amount │ cost │ isyellow │ │ │ │ String │ Int64 │ Float64 │ Bool │ │ ├─────┼────────┼────────┼─────────┼──────────┤ │ │ 1 │ Apple │ 2 │ 1.2 │ 0 │ │ │ 2 │ Banana │ 6 │ 2.0 │ 1 │ │ │ 3 │ Cherry │ 1000 │ 0.4 │ 0 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(fruit=["Apple","Banana","Cherry"],amount=[2,6,1000],price=[1.2,2.0,0.4],isyellow=[false,true,false]) │ │ q = df |> @rename(:fruit => :food, :price => :cost, :food => :name) |> DataFrame │ │ println(q) │ │ Evaluated output: │ │ 3×4 DataFrame │ Row │ name amount cost isyellow │ │ String Int64 Float64 Bool │ ─────┼─────────────────────────────────── │ 1 │ Apple 2 1.2 false │ 2 │ Banana 6 2.0 true │ 3 │ Cherry 1000 0.4 false │ │ Expected output: │ │ 3×4 DataFrame │ │ Row │ name │ amount │ cost │ isyellow │ │ │ │ String │ Int64 │ Float64 │ Bool │ │ ├─────┼────────┼────────┼─────────┼──────────┤ │ │ 1 │ Apple │ 2 │ 1.2 │ 0 │ │ │ 2 │ Banana │ 6 │ 2.0 │ 1 │ │ │ 3 │ Cherry │ 1000 │ 0.4 │ 0 │ │ │ diff = │ Warning: Diff output requires color. │ 3×4 DataFrame │ │ DataFrame │ Row │ name │ amount │ cost │ isyellow │ │ │ │ String │ Int64 │ Float64 │ Bool │ │ ├─────┼────────┼────────┼─────────┼──────────┤ │ │ 1 name amount cost isyellow │ │ Apple String Int64 Float64 Bool │ ─────┼─────────────────────────────────── │ 1 │ Apple 2 │ 1.2 │ 0 │ │ │ 2 │ Banana false │ 2 │ Banana 6 │ 2.0 │ 1 │ │ │ 3 │ Cherry │ 1000 2.0 true │ 3 │ Cherry 1000 0.4 │ 0 │false └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:327 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:349-367 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(fruit=["Apple","Banana","Cherry"],amount=[2,6,1000],price=[1.2,2.0,0.4],isyellow=[false,true,false]) │ │ q = df |> @mutate(price = 2 * _.price + _.amount, isyellow = _.fruit == "Apple") |> DataFrame │ │ println(q) │ │ # output │ │ 3×4 DataFrame │ │ Row │ fruit │ amount │ price │ isyellow │ │ │ │ String │ Int64 │ Float64 │ Bool │ │ ├─────┼────────┼────────┼─────────┼──────────┤ │ │ 1 │ Apple │ 2 │ 4.4 │ 1 │ │ │ 2 │ Banana │ 6 │ 10.0 │ 0 │ │ │ 3 │ Cherry │ 1000 │ 1000.8 │ 0 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(fruit=["Apple","Banana","Cherry"],amount=[2,6,1000],price=[1.2,2.0,0.4],isyellow=[false,true,false]) │ │ q = df |> @mutate(price = 2 * _.price + _.amount, isyellow = _.fruit == "Apple") |> DataFrame │ │ println(q) │ │ Evaluated output: │ │ 3×4 DataFrame │ Row │ fruit amount price isyellow │ │ String Int64 Float64 Bool │ ─────┼─────────────────────────────────── │ 1 │ Apple 2 4.4 true │ 2 │ Banana 6 10.0 false │ 3 │ Cherry 1000 1000.8 false │ │ Expected output: │ │ 3×4 DataFrame │ │ Row │ fruit │ amount │ price │ isyellow │ │ │ │ String │ Int64 │ Float64 │ Bool │ │ ├─────┼────────┼────────┼─────────┼──────────┤ │ │ 1 │ Apple │ 2 │ 4.4 │ 1 │ │ │ 2 │ Banana │ 6 │ 10.0 │ 0 │ │ │ 3 │ Cherry │ 1000 │ 1000.8 │ 0 │ │ │ diff = │ Warning: Diff output requires color. │ 3×4 DataFrame │ │ DataFrame │ Row │ fruit │ amount │ price │ isyellow │ │ │ │ String │ Int64 │ Float64 │ Bool │ │ ├─────┼────────┼────────┼─────────┼──────────┤ │ │ 1 fruit amount price isyellow │ │ Apple String Int64 Float64 Bool │ ─────┼─────────────────────────────────── │ 1 │ Apple 2 │ 4.4 │ 1 │ │ │ 2 │ Banana │ 6 │ 10.0 │ 0 │ │ │ 3 4.4 true │ 2 │ Cherry Banana 6 10.0 false │ 3 │ Cherry 1000 │ 1000.8 │ 0 │1000.8 false └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:349 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:375-392 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(a=[1,2,3], b=[4,missing,5]) │ │ q = df |> @dropna() |> DataFrame │ │ println(q) │ │ # output │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 5 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(a=[1,2,3], b=[4,missing,5]) │ │ q = df |> @dropna() |> DataFrame │ │ println(q) │ │ Evaluated output: │ │ 2×2 DataFrame │ Row │ a b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 1 4 │ 2 │ 3 5 │ │ Expected output: │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 5 │ │ │ diff = │ Warning: Diff output requires color. │ 2×2 DataFrame │ │ DataFrame │ Row │ a a b │ │ b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 5 │1 4 │ 2 │ 3 5 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:375 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:396-413 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(a=[1,2,3], b=[4,missing,5]) │ │ q = df |> @dropna(:b) |> DataFrame │ │ println(q) │ │ # output │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 5 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(a=[1,2,3], b=[4,missing,5]) │ │ q = df |> @dropna(:b) |> DataFrame │ │ println(q) │ │ Evaluated output: │ │ 2×2 DataFrame │ Row │ a b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 1 4 │ 2 │ 3 5 │ │ Expected output: │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 5 │ │ │ diff = │ Warning: Diff output requires color. │ 2×2 DataFrame │ │ DataFrame │ Row │ a a b │ │ b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 5 │1 4 │ 2 │ 3 5 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:396 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:417-434 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(a=[1,2,3], b=[4,missing,5]) │ │ q = df |> @dropna(:b, :a) |> DataFrame │ │ println(q) │ │ # output │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 5 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(a=[1,2,3], b=[4,missing,5]) │ │ q = df |> @dropna(:b, :a) |> DataFrame │ │ println(q) │ │ Evaluated output: │ │ 2×2 DataFrame │ Row │ a b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 1 4 │ 2 │ 3 5 │ │ Expected output: │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 5 │ │ │ diff = │ Warning: Diff output requires color. │ 2×2 DataFrame │ │ DataFrame │ Row │ a a b │ │ b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 5 │1 4 │ 2 │ 3 5 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:417 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:442-459 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(a=[1,missing,3], b=[4,5,6]) │ │ q = df |> @filter(!isna(_.a)) |> @dissallowna() |> DataFrame │ │ println(q) │ │ # output │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 6 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(a=[1,missing,3], b=[4,5,6]) │ │ q = df |> @filter(!isna(_.a)) |> @dissallowna() |> DataFrame │ │ println(q) │ │ Evaluated output: │ │ 2×2 DataFrame │ Row │ a b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 1 4 │ 2 │ 3 6 │ │ Expected output: │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 6 │ │ │ diff = │ Warning: Diff output requires color. │ 2×2 DataFrame │ │ DataFrame │ Row │ a a b │ │ b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 3 │ 6 │1 4 │ 2 │ 3 6 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:442 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:463-480 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(a=[1,2,missing], b=[4,missing,5]) │ │ q = df |> @filter(!isna(_.b)) |> @dissallowna(:b) |> DataFrame │ │ println(q) │ │ # output │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64⍰ │ Int64 │ │ ├─────┼─────────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ missing │ 5 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(a=[1,2,missing], b=[4,missing,5]) │ │ q = df |> @filter(!isna(_.b)) |> @dissallowna(:b) |> DataFrame │ │ println(q) │ │ Evaluated output: │ │ 2×2 DataFrame │ Row │ a b │ │ Int64? Int64 │ ─────┼──────────────── │ 1 │ 1 4 │ 2 │ missing 5 │ │ Expected output: │ │ 2×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64⍰ │ Int64 │ │ ├─────┼─────────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ missing │ 5 │ │ │ diff = │ Warning: Diff output requires color. │ 2×2 DataFrame │ │ DataFrame │ Row │ a │ b │ │ │ │ Int64⍰ │ Int64 │ │ ├─────┼─────────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 a b │ │ missing Int64? Int64 │ ─────┼──────────────── │ 1 │ 1 4 │ 2 │ 5 │missing 5 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:463 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:492-510 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(a=[1,missing,3], b=[4,5,6]) │ │ q = df |> @replacena(0) |> DataFrame │ │ println(q) │ │ # output │ │ 3×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 0 │ 5 │ │ │ 3 │ 3 │ 6 │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(a=[1,missing,3], b=[4,5,6]) │ │ q = df |> @replacena(0) |> DataFrame │ │ println(q) │ │ Evaluated output: │ │ 3×2 DataFrame │ Row │ a b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ 1 4 │ 2 │ 0 5 │ 3 │ 3 6 │ │ Expected output: │ │ 3×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 0 │ 5 │ │ │ 3 │ 3 │ 6 │ │ │ diff = │ Warning: Diff output requires color. │ 3×2 DataFrame │ │ DataFrame │ Row │ a a b │ │ b │ │ Int64 Int64 │ ─────┼────────────── │ 1 │ │ Int64 │ Int64 │ │ ├─────┼───────┼───────┤ │ │ 1 │ 1 │ 4 │ │ │ 2 │ 0 │ 5 │ │ │ 3 │ 3 │ 6 │1 4 │ 2 │ 0 5 │ 3 │ 3 6 └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:492 ┌ Error: doctest failure in ../docs/src/standalonequerycommands.md:514-532 │ │ ```jldoctest │ using Query, DataFrames │ │ df = DataFrame(a=[1,2,missing], b=["One",missing,"Three"]) │ │ q = df |> @replacena(:b=>"Unknown", :a=>0) |> DataFrame │ │ println(q) │ │ # output │ │ 3×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ String │ │ ├─────┼───────┼─────────┤ │ │ 1 │ 1 │ One │ │ │ 2 │ 2 │ Unknown │ │ │ 3 │ 0 │ Three │ │ ``` │ │ Subexpression: │ │ using Query, DataFrames │ │ df = DataFrame(a=[1,2,missing], b=["One",missing,"Three"]) │ │ q = df |> @replacena(:b=>"Unknown", :a=>0) |> DataFrame │ │ println(q) │ │ Evaluated output: │ │ 3×2 DataFrame │ Row │ a b │ │ Int64 String │ ─────┼──────────────── │ 1 │ 1 One │ 2 │ 2 Unknown │ 3 │ 0 Three │ │ Expected output: │ │ 3×2 DataFrame │ │ Row │ a │ b │ │ │ │ Int64 │ String │ │ ├─────┼───────┼─────────┤ │ │ 1 │ 1 │ One │ │ │ 2 │ 2 │ Unknown │ │ │ 3 │ 0 │ Three │ │ │ diff = │ Warning: Diff output requires color. │ 3×2 DataFrame │ │ DataFrame │ Row │ a a b │ │ b │ │ Int64 String │ ─────┼──────────────── │ 1 │ │ Int64 │ String │ │ ├─────┼───────┼─────────┤ │ │ 1 │ 1 │ One │ │ │ 2 │ 2 │ Unknown │ │ │ 3 │ 0 │ Three │1 One │ 2 │ 2 Unknown │ 3 │ 0 Three └ @ Documenter ~/.julia/packages/Query/85Sw7/docs/src/standalonequerycommands.md:514 ┌ Error: Doctesting failed │ exception = │ `makedocs` encountered a doctest error. Terminating build │ Stacktrace: │ [1] error(s::String) │ @ Base ./error.jl:35 │ [2] runner(::Type{Documenter.Builder.Doctest}, doc::Documenter.Document) │ @ Documenter ~/.julia/packages/Documenter/tbj1p/src/builder_pipeline.jl:213 │ [3] dispatch(::Type{Documenter.Builder.DocumentPipeline}, x::Documenter.Document) │ @ Documenter.Selectors ~/.julia/packages/Documenter/tbj1p/src/utilities/Selectors.jl:170 │ [4] #90 │ @ ~/.julia/packages/Documenter/tbj1p/src/makedocs.jl:275 [inlined] │ [5] withenv(::Documenter.var"#90#92"{Documenter.Document}, ::Pair{String, Nothing}, ::Vararg{Pair{String, Nothing}}) │ @ Base ./env.jl:265 │ [6] #89 │ @ ~/.julia/packages/Documenter/tbj1p/src/makedocs.jl:274 [inlined] │ [7] cd(f::Documenter.var"#89#91"{Documenter.Document}, dir::String) │ @ Base.Filesystem ./file.jl:112 │ [8] makedocs(; debug::Bool, format::Documenter.HTMLWriter.HTML, kwargs::@Kwargs{root::String, source::String, sitename::String, doctest::Symbol, modules::Vector{Module}, doctestfilters::Vector{Regex}, remotes::Nothing, plugins::Vector{Documenter.Plugin}}) │ @ Documenter ~/.julia/packages/Documenter/tbj1p/src/makedocs.jl:273 │ [9] (::Documenter.var"#all_doctests#135"{Bool, Vector{Regex}, Vector{Documenter.Plugin}, Vector{Module}})() │ @ Documenter ~/.julia/packages/Documenter/tbj1p/src/doctest.jl:85 │ [10] macro expansion │ @ ~/.julia/packages/Documenter/tbj1p/src/doctest.jl:110 [inlined] │ [11] macro expansion │ @ /opt/julia/share/julia/stdlib/v1.11/Test/src/Test.jl:676 [inlined] │ [12] macro expansion │ @ ~/.julia/packages/Documenter/tbj1p/src/doctest.jl:110 [inlined] │ [13] macro expansion │ @ /opt/julia/share/julia/stdlib/v1.11/Test/src/Test.jl:1704 [inlined] │ [14] doctest(source::String, modules::Vector{Module}; fix::Bool, testset::String, doctestfilters::Vector{Regex}, plugins::Vector{Documenter.Plugin}) │ @ Documenter ~/.julia/packages/Documenter/tbj1p/src/doctest.jl:110 │ [15] doctest │ @ ~/.julia/packages/Documenter/tbj1p/src/doctest.jl:69 [inlined] │ [16] doctest(package::Module; manual::Bool, testset::Nothing, kwargs::@Kwargs{}) │ @ Documenter ~/.julia/packages/Documenter/tbj1p/src/doctest.jl:37 │ [17] doctest(package::Module) │ @ Documenter ~/.julia/packages/Documenter/tbj1p/src/doctest.jl:20 │ [18] macro expansion │ @ ~/.julia/packages/Query/85Sw7/test/runtests.jl:501 [inlined] │ [19] macro expansion │ @ /opt/julia/share/julia/stdlib/v1.11/Test/src/Test.jl:1704 [inlined] │ [20] top-level scope │ @ ~/.julia/packages/Query/85Sw7/test/runtests.jl:15 │ [21] include(fname::String) │ @ Main ./sysimg.jl:38 │ [22] top-level scope │ @ none:6 │ [23] eval │ @ ./boot.jl:430 [inlined] │ [24] exec_options(opts::Base.JLOptions) │ @ Base ./client.jl:296 │ [25] _start() │ @ Base ./client.jl:531 └ @ Documenter ~/.julia/packages/Documenter/tbj1p/src/doctest.jl:99 Doctests: Query: Test Failed at /home/pkgeval/.julia/packages/Documenter/tbj1p/src/doctest.jl:110 Expression: all_doctests() Stacktrace: [1] macro expansion @ /opt/julia/share/julia/stdlib/v1.11/Test/src/Test.jl:679 [inlined] [2] macro expansion @ ~/.julia/packages/Documenter/tbj1p/src/doctest.jl:110 [inlined] [3] macro expansion @ /opt/julia/share/julia/stdlib/v1.11/Test/src/Test.jl:1704 [inlined] [4] doctest(source::String, modules::Vector{Module}; fix::Bool, testset::String, doctestfilters::Vector{Regex}, plugins::Vector{Documenter.Plugin}) @ Documenter ~/.julia/packages/Documenter/tbj1p/src/doctest.jl:110 Test Summary: | Pass Fail Total Time Queries | 261 1 262 2m44.0s Utilities | 17 17 0.7s shift_access! | 2 2 0.2s a.b Syntax (dplyr API) | 8 8 3.2s Pipe Syntax | 4 4 1.3s Select Macro | 13 13 7.5s Rename Macro | 6 6 2.6s Mutate Macro | 3 3 0.9s @dropna | 6 6 2.1s @replacena | 6 6 1.0s @dissallowna | 4 4 1.0s Doctests: Query | 1 1 1m40.1s ERROR: LoadError: Some tests did not pass: 261 passed, 1 failed, 0 errored, 0 broken. in expression starting at /home/pkgeval/.julia/packages/Query/85Sw7/test/runtests.jl:13 Testing failed after 197.08s ERROR: LoadError: Package Query errored during testing Stacktrace: [1] pkgerror(msg::String) @ Pkg.Types /opt/julia/share/julia/stdlib/v1.11/Pkg/src/Types.jl:68 [2] test(ctx::Pkg.Types.Context, pkgs::Vector{Pkg.Types.PackageSpec}; coverage::Bool, julia_args::Cmd, test_args::Cmd, test_fn::Nothing, force_latest_compatible_version::Bool, allow_earlier_backwards_compatible_versions::Bool, allow_reresolve::Bool) @ Pkg.Operations /opt/julia/share/julia/stdlib/v1.11/Pkg/src/Operations.jl:2124 [3] test @ /opt/julia/share/julia/stdlib/v1.11/Pkg/src/Operations.jl:2007 [inlined] [4] test(ctx::Pkg.Types.Context, pkgs::Vector{Pkg.Types.PackageSpec}; coverage::Bool, test_fn::Nothing, julia_args::Cmd, test_args::Cmd, force_latest_compatible_version::Bool, allow_earlier_backwards_compatible_versions::Bool, allow_reresolve::Bool, kwargs::@Kwargs{io::IOContext{IO}}) @ Pkg.API /opt/julia/share/julia/stdlib/v1.11/Pkg/src/API.jl:481 [5] test(pkgs::Vector{Pkg.Types.PackageSpec}; io::IOContext{IO}, kwargs::@Kwargs{julia_args::Cmd}) @ Pkg.API /opt/julia/share/julia/stdlib/v1.11/Pkg/src/API.jl:159 [6] test @ /opt/julia/share/julia/stdlib/v1.11/Pkg/src/API.jl:147 [inlined] [7] #test#74 @ /opt/julia/share/julia/stdlib/v1.11/Pkg/src/API.jl:146 [inlined] [8] top-level scope @ /PkgEval.jl/scripts/evaluate.jl:219 in expression starting at /PkgEval.jl/scripts/evaluate.jl:210 PkgEval failed after 265.56s: package has test failures