Select a column with a keyword name
use backtick to escape keyword instead. just like how you created your table. using double quote or single quote will parse it into string that is why you’re getting two records of and select `AND` from test;
use backtick to escape keyword instead. just like how you created your table. using double quote or single quote will parse it into string that is why you’re getting two records of and select `AND` from test;
You can just get/set the index via its name property In [7]: df.index.name Out[7]: ‘Index Title’ In [8]: df.index.name=”foo” In [9]: df.index.name Out[9]: ‘foo’ In [10]: df Out[10]: Column 1 foo Apples 1 Oranges 2 Puppies 3 Ducks 4