I have a gazillion CSV files and in column 2 is the x-data and column 3 is the y-data. Each CSV file is a different time stamp. The x-data is slightly different in each file, but the number of rows is constant. I'm happy to assume the x-data is in fact identical.
I am persuaded that Tableau is a good interface for me to do some visualization and happily installed tabpy and "voila", I can call python from Tableau... except...  to return an array I will need to return a string with comma separated values for each time stamp, and then one of those strings per x-axis and then.... Hmm, that doesnt sound right.
I tried telling Tableau just open them all and I'd join them later, but gave up after 30 mins of it crunching.
So what do you reckon? I am completely agnostic. Install an SQL server and create a database? Create a big CSV file that has a time-stamp for each column? Google? JSON?
Or maybe there is some clever way in Tableau to loop through the CSV files?
I would suggest doing any data prep outside of Tableau. Since you seem to be familiar with Python, try Pandas to combine all the csv files into one dataframe then output to a database or a single csv. Then connect to that single source.
Load thousands of CSV files into tableau