Creating a dataframe using CSV files - GeeksforGeeks

CSV files are the “comma-separated values”, these values are separated by commas, this file can be viewed like an excel file. In Python ... Skiptocontent CoursesGeekWeek2022ForWorkingProfessionalsDSAClasses(Live)SystemDesign(Live)JavaBackendDeveloper(Live)FullStack(Live)ExploreMoreLiveCoursesDSA(Self-Paced)SDETheory(Self-Paced)AllDevelopmentCourses(Self-Paced)ExploreMoreSelf-PacedCoursesForStudentsCompetitiveProgramming(Live)GATECourse2023(Live)DataScience(Live)ExploreMoreLiveCoursesDSA(Self-Paced)CIP(Self-Paced)JAVA/Python/C++(Self-Paced)ExploreMoreSelf-PacedCoursesSchoolCoursesSchoolGuidePythonProgrammingLearnToMakeAppsExploremoreAllCoursesTutorialsAlgorithmsAnalysisofAlgorithmsAsymptoticAnalysisWorst,AverageandBestCasesAsymptoticNotationsLittleoandlittleomeganotationsLowerandUpperBoundTheoryAnalysisofLoopsSolvingRecurrencesAmortizedAnalysisWhatdoes'SpaceComplexity'mean?Pseudo-polynomialAlgorithmsPolynomialTimeApproximationSchemeATimeComplexityQuestionSearchingAlgorithmsSortingAlgorithmsGraphAlgorithmsPatternSearchingGeometricAlgorithmsMathematicalBitwiseAlgorithmsRandomizedAlgorithmsGreedyAlgorithmsDynamicProgrammingDivideandConquerBacktrackingBranchandBoundAllAlgorithmsDataStructuresArraysLinkedListStackQueueBinaryTreeBinarySearchTreeHeapHashingGraphAdvancedDataStructureMatrixStringsAllDataStructuresInterviewCornerCompanyPreparationTopTopicsPracticeCompanyQuestionsInterviewExperiencesExperiencedInterviewsInternshipInterviewsCompetititveProgrammingDesignPatternsSystemDesignTutorialMultipleChoiceQuizzesLanguagesCC++JavaPythonC#SQLScalaPerlGoLanguageKotlinWebDevelopmentHTMLCSSJavaScriptPHPCSSFrameworksBootstrapTailwindCSSFoundationCSSMaterializeCSSBulmaPureCSSPrimerCSSBlazeUISemanticUIJavaScriptFrameworksAngularJSNodeJSJavaScriptLibrariesjQueryReactJSML&DataScienceMachineLearningDataScienceCSSubjectsMathematicsOperatingSystemDBMSComputerNetworksComputerOrganizationandArchitectureTheoryofComputationCompilerDesignDigitalLogicSoftwareEngineeringGATEGATEComputerScienceNotesLastMinuteNotesGATECSSolvedPapersGATECSOriginalPapersandOfficialKeysGATE2021DatesGATECS2021SyllabusImportantTopicsforGATECSSoftwareDesignsSoftwareDesignPatternsSystemDesignTutorialGFGSheetsWebDevCheatSheetsHTMLCheatSheetCSSCheatSheetJSCheatSheetjQueryCheatSheetCompany-WiseSDESheetsFacebookSDESheetAmazonSDESheetAppleSDESheetNetflixSDESheetGoogleSDESheetWiproCodingSheetInfosysCodingSheetTCSCodingSheetCognizantCodingSheetHCLCodingSheetDSASheetsSDESheetFAANGCodingSheetLoveBabbarSheetMassRecruiterSheetProduct-BasedCodingSheetCompany-WisePreparationSheetArraySheetStringSheetTreeSheetGraphSheetDPSheetSchoolLearningSchoolProgrammingMathematicsNumberSystemAlgebraTrigonometryStatisticsProbabilityGeometryMensurationCalculusMathsNotes(Class8-12)Class8NotesClass9NotesClass10NotesClass11NotesClass12NotesNCERTSolutionsClass8MathsSolutionClass9MathsSolutionClass10MathsSolutionClass11MathsSolutionClass12MathsSolutionRDSharmaSolutionsClass8MathsSolutionClass9MathsSolutionClass10MathsSolutionClass11MathsSolutionClass12MathsSolutionPhysicsNotes(Class8-11)Class8NotesClass9NotesClass10NotesClass11NotesChemistryNotesClass8NotesClass9NotesClass10NotesBusinessStudies(Class11th)BusinessStudies(Class12th)CSExams/PSUsISROISROCSOriginalPapersandOfficialKeysISROCSSolvedPapersISROCSSyllabusforScientist/EngineerExamUGCNETUGCNETCSNotesPaperIIUGCNETCSNotesPaperIIIUGCNETCSSolvedPapersStudentCampusAmbassadorProgramSchoolAmbassadorProgramProjectGeekoftheMonthCampusGeekoftheMonthPlacementCourseCompetititveProgrammingTestimonialsStudentChapterGeekontheTopInternshipCareersUPSCGeographyNotesHistoryNotesScience&Tech.NotesEthicsNotesPolityNotesEconomicsNotesUPSCPreviousYearPapersSSCCGLSSCCGLSyllabusGeneralStudiesEnglishReasoningSubjectwisePracticePapersPreviousYearPapersBankingExamsSBIClerkSBIClerkSyllabusGeneralAwarenessEnglishQuantitativeAptitudeReasoningAbilitySBIClerkPracticePapersSBIPOSBIPOSyllabusGeneralAwarenessEnglishQuantitativeAptitudeReasoningAbilityPreviousYearPapersSBIPOPracticePapersIBPSPOIBPSPO2022SyllabusEnglishNotesReasoningNotesPreviousYearPapersMockQuestionPapersIBPSClerkIBPSClerkSyllabusEnglishNotesPreviousYearPapersJobsApplyforJobsPostaJobHirewithUsKnowaboutJobathonJobathonPracticeAllDSAProblemsProblemoftheDayInterviewSeries:WeeklyContestsBi-WizardCoding:SchoolContestsEventsPracticeSDESheetCuratedDSAListsTop50ArrayProblemsTop50StringProblemsTop50TreeProblemsTop50GraphProblemsTop50DPProblemsContests HomeSavedVideosCoursesGBlogPuzzlesWhat'sNew? ChangeLanguage DataStructuresAlgorithmsInterviewPreparationTopic-wisePracticeC++JavaPythonCompetitiveProgrammingMachineLearningJavaScriptSDESheetPuzzlesGFGSchoolProjects RelatedArticles ▲RelatedArticlesAddingnewcolumntoexistingDataFrameinPandasPythonmap()functionReadJSONfileusingPythonTakinginputinPythonHowtogetcolumnnamesinPandasdataframeReadafilelinebylineinPythonPythonDictionaryIterateoveralistinPythonPythonprogramtoconvertalisttostringReadingandWritingtotextfilesinPythonPythonString|replace()Enumerate()inPythonDifferentwaystocreatePandasDataframesum()functioninPythonPrintlistsinPython(5DifferentWays)isupper(),islower(),lower(),upper()inPythonandtheirapplicationsConvertintegertostringinPython*argsand**kwargsinPythonPython|GetalistasinputfromuserPythonListsPython|ProgramtoconvertStringtoaListPythonString|split()CreateaPandasDataFramefromListsfloor()andceil()functionPythonGraphPlottinginPython|Set1GETandPOSTrequestsusingPythonTakingmultipleinputsfromuserinPythonFindaverageofalistinpythonStackinPythonHowtoInstallPIPonWindows?AddingnewcolumntoexistingDataFrameinPandasPythonmap()functionReadJSONfileusingPythonTakinginputinPythonHowtogetcolumnnamesinPandasdataframeReadafilelinebylineinPythonPythonDictionaryIterateoveralistinPythonPythonprogramtoconvertalisttostringReadingandWritingtotextfilesinPythonPythonString|replace()Enumerate()inPythonDifferentwaystocreatePandasDataframesum()functioninPythonPrintlistsinPython(5DifferentWays)isupper(),islower(),lower(),upper()inPythonandtheirapplicationsConvertintegertostringinPython*argsand**kwargsinPythonPython|GetalistasinputfromuserPythonListsPython|ProgramtoconvertStringtoaListPythonString|split()CreateaPandasDataFramefromListsfloor()andceil()functionPythonGraphPlottinginPython|Set1GETandPOSTrequestsusingPythonTakingmultipleinputsfromuserinPythonFindaverageofalistinpythonStackinPythonHowtoInstallPIPonWindows?CreatingadataframeusingCSVfilesViewDiscussion ImproveArticle SaveArticle LikeArticle DifficultyLevel: MediumLastUpdated: 17Feb,2022ReadDiscussViewDiscussion ImproveArticle SaveArticle LikeArticle CSVfilesarethe“comma-separatedvalues”,thesevaluesareseparatedbycommas,thisfilecanbeviewedlikeanexcelfile.InPython,Pandasisthemostimportantlibrarycomingtodatascience.Weneedtodealwithhugedatasetswhileanalyzingthedata,whichusuallycangetinCSVfileformat.CreatingapandasdataframeusingCSVfilescanbeachievedinmultipleways.Note:Getthecsvfileusedinthebelowexamplesfromhere.Method#1:Usingread_csv()method:read_csv()isanimportantpandasfunctiontoreadcsvfilesanddooperationsonit.Example:  Python3#Pythonprogramtoillustrate#creatingadataframeusingCSVfiles #importpandasmoduleimportpandasaspd #creatingadataframedf=pd.read_csv("CardioGoodFitness.csv")print(df.head())Output: Method#2:Usingread_table()method:read_table()isanotherimportantpandasfunctiontoreadcsvfilesandcreatedataframefromit.Example:  Python3#Pythonprogramtoillustrate#creatingadataframeusingCSVfiles #importpandasmoduleimportpandasaspd #creatingadataframedf=pd.read_table("CardioGoodFitness.csv",delimiter=",")print(df.head())Output: Method#3:Usingthecsvmodule:Onecandirectlyimportthecsvfilesusingthecsvmoduleandthencreateadataframeusingthatcsvfile.Example:  Python3#Pythonprogramtoillustrate#creatingadataframeusingCSVfiles #importpandasmoduleimportpandasaspd#importcsvmoduleimportcsv withopen("CardioGoodFitness.csv")ascsv_file:    #readthecsvfile    csv_reader=csv.reader(csv_file)     #nowwecanusethiscsvfilesintothepandas    df=pd.DataFrame([csv_reader],index=None) #iteratingvaluesoffirstcolumnforvalinlist(df[1]):    print(val)Output:  ['TM195','18','Male','14','Single','3','4','29562','112'] MyPersonalNotes arrow_drop_upSave LikePreviousPython-ElementsfrequencyinTupleMatrixNext SelfOrganizingMaps-KohonenMapsRecommendedArticlesPage:06,May2106,May2131,Dec1822,Jan2002,Dec2013,Jan2113,May2119,Sep2125,Dec2016,Dec1926,Dec1901,Jul2020,Jun2005,Oct2023,Feb2101,Apr2116,Apr2125,Mar2109,Dec1616,Dec2108,Oct2006,Jul2022,Jan2106,Jul20ArticleContributedBy:AmiyaRanjanRout@AmiyaRanjanRoutVotefordifficultyCurrentdifficulty: MediumEasy Normal Medium Hard ExpertImprovedBy:punamsingh628700ArticleTags:Pythonpandas-dataFramePython-pandasPythonPracticeTags:pythonReportIssueWritingcodeincomment? Pleaseuseide.geeksforgeeks.org, generatelinkandsharethelinkhere. LoadCommentsPleaseLogintocomment...What'sNewViewDetailsViewDetailsViewDetailsImproveyourCodingSkillswithPracticeTryIt! Weusecookiestoensureyouhavethebestbrowsingexperienceonourwebsite.Byusingoursite,you acknowledgethatyouhavereadandunderstoodour CookiePolicy& PrivacyPolicy GotIt! StartYourCodingJourneyNow!Login Register