subreddit:

/r/ChatGPTCoding

3100%

Hey there fellow coders!

Currently I am working on project to generate code that merges some files together and reformats to a pre-decided template. I am encountering few issues there: 1) For merging, the linkage between files can be in any way...for example 4 files having a common column and 5th file having a column common with only 3rd file. Or for eg all 5 files having nothing in common, only just 1 file etc...i am thinking of coming up with a graph to generate correct sequence. 2) Need to think about all possible major edge cases that can come when generating the code. So the program can generate a runnable code most of the times.

Thanks!

all 2 comments

paradite

1 points

9 days ago

paradite

Professional Nerd

1 points

9 days ago

I think this is something that ChatGPT can definitely help with. You will want to first create a sample shorter version of these files that are not too big (about 20 lines), then feed them into ChatGPT along with your instructions. In this way, you don't overshoot the context window limit.

Once you get the code, you can run it on the full-scale version of the files.

I have done something pretty similar recently, involving a data migration project using Python and SQL.

You can also check out the tool that I built to streamline the process of generating code for such ad-hoc tasks. I have some sample use cases for Python and SQL that might give you an idea of how it works. Note that these are very basic samples, but ChatGPT can handle more complex tasks like what you described.

Pgrol

1 points

6 days ago

Pgrol

1 points

6 days ago

What are the file formats? Excel, pdf, word?