DataFrame Blog 2 CSV Files
Unit 1 – Data Handling I Chapter 2 DataFrames: 1. Creation – ▪ from dictionary of Series, ▪ list of dictionaries, ▪ Text/CSV files; 2. Display of the dataframe 3. Iteration of rows and columns 4. Addition of a row or a column to a dataframe 5. Deletion of a row or a column to a dataframe 6. Merging of rows / columns / dataframe to other dataframes. 7. Indexing using Labels, Boolean Indexing; CSV file - Comma Separated Value Files. These files are ordinary text files where data is stored in rows and the column values are separated by comma or blank space or tab spaces. These separation is also termed as delimition or we say the data are delimited with a comma or tab space. The data is when separated with spaces then it is said to be fixed. Creating a CSV File - Stage 1 --> 1. Open any text editor file say Notepad or TextEdit 2. Enter the data like this - Roll_No,Name,Percentage 1,Abhishek, 99,97 2,Ami...