Since the creation of python reading in files has become much easier with each update ... it has the functionality to edit and subset the data along with writing the edited data back to a csv or excel ...

Now imagine combining Excel’s familiar interface with the analytical power of Python—suddenly ... Connect to a large sales dataset stored in a CSV file using Power Query.