How to transform data like, in pandas or query language

Questions
1

Describe the issue/error/question

I would like to find which node is most ideal for data transformation , i can work with python & sql

Please share the workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.7
  • Database you’re using (default: SQLite): postgres
  • Running n8n with the execution process [own(default), main]: default
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: desktop app
2

Hey @kayjey,

I guess it depends really, You could use the Code node and import an npm package if you are handy with Javascript or if you want to use Pandas you could use the SSH node to connect to a host that has Python and Pandas installed or as you are using Desktop if you have Python installed you could just use the Execute command node.