Q.Besides comma, what are the other allowed characters that can be used as a separator while creating a CSV file frmo a DataFrame?

When you open a spreadsheet in Excel or Google Sheets, the program automatically figures out where each column starts and ends, what the first row means, and how to treat numbers versus text. Pandas' read_csv function does the same thing for a CSV file — but because it's code, you have to tell it exactly how to behave. The parameters are the instructions you give it so it doesn't guess wrong.

A CSV file is just a plain text file where commas separate values. But real-world data is messy: sometimes the separator is a semicolon, sometimes the first row isn't a header, sometimes there are blank lines, and sometimes dates are written in a format Pandas doesn't recognise. Each parameter solves one of these problems.

The most important parameter is filepath_or_buffer — that's just the location of your file, like "sales_data.csv". Everything else is optional but often essential.

sep (or delimiter) tells Pandas what character separates your columns. If your file uses semicolons instead of commas (common in European data), you write sep=';'. If it's a tab-separated file, sep='\t'. Without this, Pandas assumes a comma and will mash everything into one column if it's wrong.

header controls which row becomes the column names. By default, Pandas assumes the first row is the header (header=0). If your file has no header row, set header=None and Pandas will assign numeric column names (0, 1, 2…). If the header is on row 3, you can write header=2 (remember, Python counts from 0).

names lets you supply your own column names as a list. This is useful when the file has no header, or when you want to rename columns on the fly. If you use names, you usually also set header=0 to skip the existing header row.

index_col tells Pandas which column to use as the row index (the labels on the left side). If your CSV has a column called "Order ID" that should be the row identifier, write index_col='Order ID' or index_col=0 for the first column.

usecols lets you load only specific columns. If your file has 50 columns but you only need three, write usecols=['Name', 'Age', 'City']. This saves memory and makes your code faster.

dtype is a dictionary that forces columns to be a certain data type. For example, if a column of numeric IDs keeps getting treated as numbers (and losing leading zeros), write dtype={'Customer ID': str}. This prevents Pandas from making assumptions.

parse_dates tells Pandas to treat certain columns as dates. If you have a column called "Order Date", write parse_dates=['Order Date']. Pandas will convert the text into proper datetime objects, which lets you sort by date, extract month or year, and plot time series.

skiprows lets you skip a specific number of rows at the top of the file, or a list of row numbers. This is useful when the CSV has explanatory text or metadata before the actual data begins.

na_values specifies which values should be treated as missing. If your file uses "N/A", "null", or "-" to mean missing data, you can write na_values=['N/A', 'null', '-']. Pandas will convert those to NaN (Not a Number), which it can handle properly. …