Sure, here is a Python function that does what you described:

```python
import csv

def sort_records(csv_filename, new_filename):
with open(csv_filename, 'r') as csv_file:
reader = csv.reader(csv_file)
data = list(reader)
header = data[0]
records = data[1:]
records.sort()
sorted_data = [header] + records

with open(new_filename, 'w', newline='') as new_file:
writer = csv.writer(new_file)
writer.writerows(sorted_data)
```

This function works as follows:

1. It opens the input CSV file and reads its contents using the `csv.reader` function. It converts the reader object to a list, which gives us a list of lists where each inner list represents a row in the CSV file.

2. It separates the header row (the first row) from the rest of the data. It then sorts the data (excluding the header) in alphabetical order. The `sort` method of a list in Python sorts the list in place, and when used on a list of lists, it sorts by the first element of each inner list, which in this case is the city name.

3. It combines the header and the sorted data into a new list.

4. It opens the output CSV file and writes the sorted data to it using the `csv.writer` function. The `writerows` method of a `csv.writer` object writes multiple rows to the CSV file.

Please note that this function assumes that the input CSV file exists and is in the correct format, and that the program has permission to create and write to the output CSV file. If these conditions are not met, the function may raise an exception.

Question

Sure, here is a Python function that does what you described:

```python
import csv

def sort_records(csv_filename, new_filename):
    with open(csv_filename, 'r') as csv_file:
        reader = csv.reader(csv_file)
        data = list(reader)
        header = data[0]
        records = data[1:]
        records.sort()
        sorted_data = [header] + records

with open(new_filename, 'w', newline='') as new_file:
        writer = csv.writer(new_file)
        writer.writerows(sorted_data)
```

This function works as follows:

1. It opens the input CSV file and reads its contents using the `csv.reader` function. It converts the reader object to a list, which gives us a list of lists where each inner list represents a row in the CSV file.

2. It separates the header row (the first row) from the rest of the data. It then sorts the data (excluding the header) in alphabetical order. The `sort` method of a list in Python sorts the list in place, and when used on a list of lists, it sorts by the first element of each inner list, which in this case is the city name.

3. It combines the header and the sorted data into a new list.

4. It opens the output CSV file and writes the sorted data to it using the `csv.writer` function. The `writerows` method of a `csv.writer` object writes multiple rows to the CSV file.

Please note that this function assumes that the input CSV file exists and is in the correct format, and that the program has permission to create and write to the output CSV file. If these conditions are not met, the function may raise an exception.

Knowee AI · Accepted Answer