how diagnose csvsql “column not found” errorHow to move column or swap two columns with csvkit?convert bcp file to standard csv fileHow do I make geojson in2csv create separate columns for longitude & latitude?How to format csv into multiline newline delimited plain text output using csvkitcsvsql in csvkit library is missing packages how to fix?How to fetch a column from csv A with a column as a key from csv BUsing csvkit to sort on multiple columns, reverse order for somecsvjoin error: “coercing to Unicode: need string or buffer, LazyFile found”csvkit in2csv - how to convert a single json object to two-column csv
What can Thomas Cook customers who have not yet departed do now it has stopped operating?
I transpose the source code, you transpose the input!
Beyond Futuristic Technology for an Alien Warship?
Windows 10 deletes lots of tiny files super slowly. Anything that can be done to speed it up?
Is the illusion created by Invoke Duplicity affected by difficult terrain?
Why does C++ have 'Undefined Behaviour' and other languages like C# or Java don't?
Why is a road bike faster than a city bike with the same effort? How much faster it can be?
My machine, client installed VPN,
Why, even after his imprisonment, people keep calling Hannibal Lecter "Doctor"?
Another student has been assigned the same MSc thesis as mine (and already defended)
Why isn't there armor to protect from spells in the Potterverse?
Why does it seem the best way to make a living is to invest in real estate?
Dynamic DataSource for Droplist in Content Editor
Would an object shot from earth fall into the sun?
Does variance make sense in a fully immutable language?
What should I consider when deciding whether to delay an exam?
Why is STARTTLS still used?
Is it ok if I haven't decided my research topic when I first meet with a potential phd advisor?
Lambda functions with template parameters, not in function parameters
After viewing logs with journalctl, how do I exit the screen that says "lines 1-2/2 (END)"?
What's the hidden joke/meaning behind "Don't drink and park - accidents cause people"?
Can I exile my opponent's Progenitus/True-Name Nemesis with Teferi, Hero of Dominaria's emblem?
Why aren't faces sharp in my f/1.8 portraits even though I'm carefully using center-point autofocus?
How far in Advance do I need to book tickets on the West Highland Line in Scotland for a Multi-part Journey?
how diagnose csvsql “column not found” error
How to move column or swap two columns with csvkit?convert bcp file to standard csv fileHow do I make geojson in2csv create separate columns for longitude & latitude?How to format csv into multiline newline delimited plain text output using csvkitcsvsql in csvkit library is missing packages how to fix?How to fetch a column from csv A with a column as a key from csv BUsing csvkit to sort on multiple columns, reverse order for somecsvjoin error: “coercing to Unicode: need string or buffer, LazyFile found”csvkit in2csv - how to convert a single json object to two-column csv
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Using csvkit on macOS 10.14.3
input file:
head -n 3 Nov_git_v2.csv
Model_var,dummy
Age,
Basket_Size_FP_24,
Basket_Size_FP_6,
csvsql --query "select Model_var from Nov_gift_v2" Nov_gift_v2.csv
produces error:
sqlite3.OperationalError) no such column: Model_var
csvstat -c 1-2 Nov_gift_v2.csv > csvstat_output.txt
displays the column "Model_var" and lists its properties, implying the column exists
csvsql --query "select Model_var from Nov_gift_v2" Nov_gift_v2.csv
expected:
Age
Basket_Size_FP_24
Basket_Size_FP_6
actual output:
sqlite3.OperationalError) no such column: Model_var
csvkit
asked Mar 28 at 18:50
PatrickRPatrickR
11 bronze badge
add a comment
|
Using csvkit on macOS 10.14.3
input file:
head -n 3 Nov_git_v2.csv
Model_var,dummy
Age,
Basket_Size_FP_24,
Basket_Size_FP_6,
csvsql --query "select Model_var from Nov_gift_v2" Nov_gift_v2.csv
produces error:
sqlite3.OperationalError) no such column: Model_var
csvstat -c 1-2 Nov_gift_v2.csv > csvstat_output.txt
displays the column "Model_var" and lists its properties, implying the column exists
csvsql --query "select Model_var from Nov_gift_v2" Nov_gift_v2.csv
expected:
Age
Basket_Size_FP_24
Basket_Size_FP_6
actual output:
sqlite3.OperationalError) no such column: Model_var
csvkit
asked Mar 28 at 18:50
PatrickRPatrickR
11 bronze badge
` csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv` """Model_var""" Model_var Model_var Model_var
– PatrickR
Apr 1 at 17:50
the query produces the output "Model_var Model_var Model_var"
– PatrickR
Apr 1 at 17:51
Do you have Python 2 or 3?
– aborruso
Apr 4 at 12:33
python 2.7.16 on /usr/local/bin/python
– PatrickR
Apr 4 at 17:56
but I see i also have python 3.7.2,which i installed...i don't remember installing 2.7, so I suspect that csvkit installed this as part of its installation, could this be so?
– PatrickR
Apr 4 at 18:00
add a comment
|
Using csvkit on macOS 10.14.3
input file:
head -n 3 Nov_git_v2.csv
Model_var,dummy
Age,
Basket_Size_FP_24,
Basket_Size_FP_6,
csvsql --query "select Model_var from Nov_gift_v2" Nov_gift_v2.csv
produces error:
sqlite3.OperationalError) no such column: Model_var
csvstat -c 1-2 Nov_gift_v2.csv > csvstat_output.txt
displays the column "Model_var" and lists its properties, implying the column exists
csvsql --query "select Model_var from Nov_gift_v2" Nov_gift_v2.csv
expected:
Age
Basket_Size_FP_24
Basket_Size_FP_6
actual output:
sqlite3.OperationalError) no such column: Model_var
csvkit
asked Mar 28 at 18:50
PatrickRPatrickR
11 bronze badge
Using csvkit on macOS 10.14.3
input file:
head -n 3 Nov_git_v2.csv
Model_var,dummy
Age,
Basket_Size_FP_24,
Basket_Size_FP_6,
csvsql --query "select Model_var from Nov_gift_v2" Nov_gift_v2.csv
produces error:
sqlite3.OperationalError) no such column: Model_var
csvstat -c 1-2 Nov_gift_v2.csv > csvstat_output.txt
displays the column "Model_var" and lists its properties, implying the column exists
csvsql --query "select Model_var from Nov_gift_v2" Nov_gift_v2.csv
expected:
Age
Basket_Size_FP_24
Basket_Size_FP_6
actual output:
sqlite3.OperationalError) no such column: Model_var
csvkit
csvkit
asked Mar 28 at 18:50
PatrickRPatrickR
11 bronze badge
asked Mar 28 at 18:50
PatrickRPatrickR
11 bronze badge
asked Mar 28 at 18:50
PatrickRPatrickR
11 bronze badge
asked Mar 28 at 18:50
PatrickRPatrickR
11 bronze badge
asked Mar 28 at 18:50
PatrickRPatrickR
11 bronze badge
11 bronze badge
` csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv` """Model_var""" Model_var Model_var Model_var
– PatrickR
Apr 1 at 17:50
the query produces the output "Model_var Model_var Model_var"
– PatrickR
Apr 1 at 17:51
Do you have Python 2 or 3?
– aborruso
Apr 4 at 12:33
python 2.7.16 on /usr/local/bin/python
– PatrickR
Apr 4 at 17:56
but I see i also have python 3.7.2,which i installed...i don't remember installing 2.7, so I suspect that csvkit installed this as part of its installation, could this be so?
– PatrickR
Apr 4 at 18:00
add a comment
|
` csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv` """Model_var""" Model_var Model_var Model_var
– PatrickR
Apr 1 at 17:50
the query produces the output "Model_var Model_var Model_var"
– PatrickR
Apr 1 at 17:51
Do you have Python 2 or 3?
– aborruso
Apr 4 at 12:33
python 2.7.16 on /usr/local/bin/python
– PatrickR
Apr 4 at 17:56
but I see i also have python 3.7.2,which i installed...i don't remember installing 2.7, so I suspect that csvkit installed this as part of its installation, could this be so?
– PatrickR
Apr 4 at 18:00
` csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv` """Model_var""" Model_var Model_var Model_var
– PatrickR
Apr 1 at 17:50
` csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv` """Model_var""" Model_var Model_var Model_var
– PatrickR
Apr 1 at 17:50
the query produces the output "Model_var Model_var Model_var"
– PatrickR
Apr 1 at 17:51
the query produces the output "Model_var Model_var Model_var"
– PatrickR
Apr 1 at 17:51
Do you have Python 2 or 3?
– aborruso
Apr 4 at 12:33
Do you have Python 2 or 3?
– aborruso
Apr 4 at 12:33
python 2.7.16 on /usr/local/bin/python
– PatrickR
Apr 4 at 17:56
python 2.7.16 on /usr/local/bin/python
– PatrickR
Apr 4 at 17:56
but I see i also have python 3.7.2,which i installed...i don't remember installing 2.7, so I suspect that csvkit installed this as part of its installation, could this be so?
– PatrickR
Apr 4 at 18:00
but I see i also have python 3.7.2,which i installed...i don't remember installing 2.7, so I suspect that csvkit installed this as part of its installation, could this be so?
– PatrickR
Apr 4 at 18:00
add a comment
|
1 Answer
1
active
oldest
votes
I have no problem with csvsql 1.0.4. What's your version (csvsql --version)?
Try with
csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv
answered Mar 31 at 20:10
aborrusoaborruso
1,0082 gold badges10 silver badges22 bronze badges
I'm on csvsql 1.0.3
– PatrickR
Apr 1 at 17:43
@PatrickR for me it works. Could you share your file (not simply cut and paste here)?
– aborruso
Apr 2 at 8:20
what's the best way to upload the file ? It's small (43 records, 1 field)
– PatrickR
Apr 2 at 22:18
@PatrickR you could use databin (databin.pudo.org) or gist (gist.github.com).
– aborruso
Apr 3 at 8:09
1
I've pasted my file to:databin.pudo.org/t/6b64b2
– PatrickR
Apr 3 at 21:22
|
show 3 more comments
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55404909%2fhow-diagnose-csvsql-column-not-found-error%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I have no problem with csvsql 1.0.4. What's your version (csvsql --version)?
Try with
csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv
answered Mar 31 at 20:10
aborrusoaborruso
1,0082 gold badges10 silver badges22 bronze badges
I'm on csvsql 1.0.3
– PatrickR
Apr 1 at 17:43
@PatrickR for me it works. Could you share your file (not simply cut and paste here)?
– aborruso
Apr 2 at 8:20
what's the best way to upload the file ? It's small (43 records, 1 field)
– PatrickR
Apr 2 at 22:18
@PatrickR you could use databin (databin.pudo.org) or gist (gist.github.com).
– aborruso
Apr 3 at 8:09
1
I've pasted my file to:databin.pudo.org/t/6b64b2
– PatrickR
Apr 3 at 21:22
|
show 3 more comments
I have no problem with csvsql 1.0.4. What's your version (csvsql --version)?
Try with
csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv
answered Mar 31 at 20:10
aborrusoaborruso
1,0082 gold badges10 silver badges22 bronze badges
I'm on csvsql 1.0.3
– PatrickR
Apr 1 at 17:43
@PatrickR for me it works. Could you share your file (not simply cut and paste here)?
– aborruso
Apr 2 at 8:20
what's the best way to upload the file ? It's small (43 records, 1 field)
– PatrickR
Apr 2 at 22:18
@PatrickR you could use databin (databin.pudo.org) or gist (gist.github.com).
– aborruso
Apr 3 at 8:09
1
I've pasted my file to:databin.pudo.org/t/6b64b2
– PatrickR
Apr 3 at 21:22
|
show 3 more comments
I have no problem with csvsql 1.0.4. What's your version (csvsql --version)?
Try with
csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv
answered Mar 31 at 20:10
aborrusoaborruso
1,0082 gold badges10 silver badges22 bronze badges
I have no problem with csvsql 1.0.4. What's your version (csvsql --version)?
Try with
csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv
answered Mar 31 at 20:10
aborrusoaborruso
1,0082 gold badges10 silver badges22 bronze badges
answered Mar 31 at 20:10
aborrusoaborruso
1,0082 gold badges10 silver badges22 bronze badges
answered Mar 31 at 20:10
aborrusoaborruso
1,0082 gold badges10 silver badges22 bronze badges
answered Mar 31 at 20:10
aborrusoaborruso
1,0082 gold badges10 silver badges22 bronze badges
1,0082 gold badges10 silver badges22 bronze badges
I'm on csvsql 1.0.3
– PatrickR
Apr 1 at 17:43
@PatrickR for me it works. Could you share your file (not simply cut and paste here)?
– aborruso
Apr 2 at 8:20
what's the best way to upload the file ? It's small (43 records, 1 field)
– PatrickR
Apr 2 at 22:18
@PatrickR you could use databin (databin.pudo.org) or gist (gist.github.com).
– aborruso
Apr 3 at 8:09
1
I've pasted my file to:databin.pudo.org/t/6b64b2
– PatrickR
Apr 3 at 21:22
|
show 3 more comments
I'm on csvsql 1.0.3
– PatrickR
Apr 1 at 17:43
@PatrickR for me it works. Could you share your file (not simply cut and paste here)?
– aborruso
Apr 2 at 8:20
what's the best way to upload the file ? It's small (43 records, 1 field)
– PatrickR
Apr 2 at 22:18
@PatrickR you could use databin (databin.pudo.org) or gist (gist.github.com).
– aborruso
Apr 3 at 8:09
1
I've pasted my file to:databin.pudo.org/t/6b64b2
– PatrickR
Apr 3 at 21:22
I'm on csvsql 1.0.3
– PatrickR
Apr 1 at 17:43
I'm on csvsql 1.0.3
– PatrickR
Apr 1 at 17:43
@PatrickR for me it works. Could you share your file (not simply cut and paste here)?
– aborruso
Apr 2 at 8:20
@PatrickR for me it works. Could you share your file (not simply cut and paste here)?
– aborruso
Apr 2 at 8:20
what's the best way to upload the file ? It's small (43 records, 1 field)
– PatrickR
Apr 2 at 22:18
what's the best way to upload the file ? It's small (43 records, 1 field)
– PatrickR
Apr 2 at 22:18
@PatrickR you could use databin (databin.pudo.org) or gist (gist.github.com).
– aborruso
Apr 3 at 8:09
@PatrickR you could use databin (databin.pudo.org) or gist (gist.github.com).
– aborruso
Apr 3 at 8:09
1
1
I've pasted my file to:databin.pudo.org/t/6b64b2
– PatrickR
Apr 3 at 21:22
I've pasted my file to:databin.pudo.org/t/6b64b2
– PatrickR
Apr 3 at 21:22
|
show 3 more comments
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55404909%2fhow-diagnose-csvsql-column-not-found-error%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
` csvsql --query 'select "Model_var" from "Nov_gift_v2"' Nov_gift_v2.csv` """Model_var""" Model_var Model_var Model_var
– PatrickR
Apr 1 at 17:50
the query produces the output "Model_var Model_var Model_var"
– PatrickR
Apr 1 at 17:51
Do you have Python 2 or 3?
– aborruso
Apr 4 at 12:33
python 2.7.16 on /usr/local/bin/python
– PatrickR
Apr 4 at 17:56
but I see i also have python 3.7.2,which i installed...i don't remember installing 2.7, so I suspect that csvkit installed this as part of its installation, could this be so?
– PatrickR
Apr 4 at 18:00