ls()
## character(0)
rm(x)
## Warning in rm(x): object 'x' not found
ls()
## character(0)
rm(list=ls())
memory.limit()
## [1] 8096
memory.size()
## [1] 30
gc()
## used (Mb) gc trigger (Mb) max used (Mb)
## Ncells 361878 19.4 592000 31.7 460000 24.6
## Vcells 547454 4.2 1023718 7.9 865028 6.6
#install.packages("data.table")
library(data.table)
getwd()
## [1] "C:/Users/Dell/Downloads"
setwd("C:/Users/Dell/Downloads")
dir()
## [1] "140749_2017.pdf"
## [2] "2011-F01-0700-Rev4-MDDS.XLSX"
## [3] "20150817143155.pdf"
## [4] "20160111060911.pdf"
## [5] "20170214052225.pdf"
## [6] "7z1604-x64.exe"
## [7] "7z1604.exe"
## [8] "861415_10151432783238421_2124270505_o (1).jpg"
## [9] "861415_10151432783238421_2124270505_o.jpg"
## [10] "AirPassengers.csv"
## [11] "ajayo.jpg"
## [12] "Alison Python Invoice - Sheet1.pdf"
## [13] "Alison SAS Invoice - Sheet1.pdf"
## [14] "All+CSV+Files+in+a+Folder.ipynb"
## [15] "Allison Interview Jones Invoice - Sheet1.pdf"
## [16] "Anaconda3-4.2.0-Windows-x86_64.exe"
## [17] "anscombe+dataset.ipynb"
## [18] "apachehttpd.exe"
## [19] "April invoice adaptive analytics - Sheet1.pdf"
## [20] "Assignment14_BusinessAnalytics (1).docx"
## [21] "Assignment14_BusinessAnalytics.docx"
## [22] "Assignment15_BusinessAnalytics.docx"
## [23] "Assignment16_BusinessAnalytics (1).docx"
## [24] "Assignment16_BusinessAnalytics (2).docx"
## [25] "Assignment16_BusinessAnalytics.docx"
## [26] "aug ust 2008.JPG"
## [27] "avast_free_antivirus_setup_online.exe"
## [28] "avinash_ltv.zip"
## [29] "BigDiamonds.csv"
## [30] "BigDiamonds.csv (1).zip"
## [31] "BigDiamonds.csv (2)"
## [32] "BigDiamonds.csv (2).zip"
## [33] "BigDiamonds.csv (3).zip"
## [34] "BigDiamonds.csv.zip"
## [35] "Boston (1).csv"
## [36] "Boston.csv"
## [37] "CAM- Ajay Ohri (1).pdf"
## [38] "CAM- Ajay Ohri.pdf"
## [39] "camtasia.exe"
## [40] "ccFraud.csv"
## [41] "Certificate of Incorporation - U74999DL2015PTC282030 (26 June 2015).pdf"
## [42] "CHAP1-6PythonforRUsersAnapproachforDataScience.docx"
## [43] "chapter+3+_+spark.html"
## [44] "chi+square+test.ipynb"
## [45] "chromeinstall-8u111.exe"
## [46] "Cisco_WebEx_Add-On.exe"
## [47] "class batch 2.R"
## [48] "class_batch_2.R"
## [49] "class_batch_2.spin.R"
## [50] "class_batch_2.spin.Rmd"
## [51] "class+exercise+data+viz.ipynb"
## [52] "class2.csv"
## [53] "Collabera Invoice (1).pdf"
## [54] "Collabera Invoice.pdf"
## [55] "Collectcent Invoice.pdf"
## [56] "college degrees.pdf"
## [57] "DAP 1.pdf"
## [58] "DAP 1.pptx"
## [59] "DAP 6 RDBMS and SQL.pdf"
## [60] "DAP 6 RDBMS and SQL.pptx"
## [61] "Data Analysis (1).7z"
## [62] "Data Analysis (1).rar"
## [63] "Data Analysis (2).rar"
## [64] "Data Analysis (3).rar"
## [65] "Data Analysis.rar"
## [66] "Data Viz.pptx"
## [67] "data+exploration.ipynb"
## [68] "data+manipulation.ipynb"
## [69] "data+munging+again.ipynb"
## [70] "data+viz.ipynb"
## [71] "data+wrangling+titanic+dataset.ipynb"
## [72] "data1.csv"
## [73] "datasets.csv"
## [74] "Decision Trees.pdf"
## [75] "DecisionStatsOfferLetter.docx"
## [76] "DecisionStatsRelievingLetter.docx"
## [77] "descriptive+stats+in+Python.ipynb"
## [78] "desktop.ini"
## [79] "Diamond (1).csv"
## [80] "Diamond (2).csv"
## [81] "Diamond (3).csv"
## [82] "Diamond (4).csv"
## [83] "Diamond (5).csv"
## [84] "Diamond (6).csv"
## [85] "Diamond (7).csv"
## [86] "Diamond (8).csv"
## [87] "Diamond.csv"
## [88] "DolbyVoiceClient.msi"
## [89] "DropboxInstaller.exe"
## [90] "edb_npgsql.exe"
## [91] "edb_pgjdbc.exe"
## [92] "edb_psqlodbc.exe"
## [93] "edb_psqlodbc.exe-20170203172812"
## [94] "edb_psqlodbc.exe-20170307203617"
## [95] "final invoice edureka - Sheet1.pdf"
## [96] "final_webinar (1).pdf"
## [97] "final_webinar.pdf"
## [98] "FinalPythonforRUsersAnapproachforDataScience (1).docx"
## [99] "FinalPythonforRUsersAnapproachforDataScience (2).docx"
## [100] "FinalPythonforRUsersAnapproachforDataScience (3).docx"
## [101] "FinalPythonforRUsersAnapproachforDataScience (4).docx"
## [102] "FinalPythonforRUsersAnapproachforDataScience.docx"
## [103] "Git-2.11.0-64-bit.exe"
## [104] "Git-2.12.0-64-bit.exe"
## [105] "GitHubSetup (1).exe"
## [106] "GitHubSetup (2).exe"
## [107] "GitHubSetup.exe"
## [108] "GOMAUDIOGLOBALSETUP.EXE"
## [109] "Hdma.csv"
## [110] "Hedonic.csv"
## [111] "HP Downloads"
## [112] "HPSupportSolutionsFramework-12.5.32.203.exe"
## [113] "image.png"
## [114] "IMS PROSCHOOL Workshop.pptx.pdf"
## [115] "IMS PROSCHOOL Workshop.pptx.pptx"
## [116] "internship.docx"
## [117] "Introduction to SAS (1).pdf"
## [118] "Introduction to SAS Part 1 (1).pdf"
## [119] "Introduction to SAS Part 1.pdf"
## [120] "Introduction to SAS.pdf"
## [121] "introductory+python.ipynb"
## [122] "Invoice for Digital Vidya.pdf"
## [123] "Invoice for Weekendr.pdf"
## [124] "Invoice format - Ajay Ohri CONTATA (1).xls"
## [125] "Invoice format - Ajay Ohri CONTATA.xls"
## [126] "invoice rapid miner.pdf"
## [127] "Invoice trafla format.docx"
## [128] "iris2 (1).ipynb"
## [129] "iris2 (2).ipynb"
## [130] "iris2.ipynb"
## [131] "January invoice Indicus .pdf"
## [132] "June AV Invoice - Sheet1.pdf"
## [133] "Lecture 6 - KNN & Naive Bayes.ppt"
## [134] "Local Disk (C) - Shortcut.lnk"
## [135] "logistic regression - script for ppt.R"
## [136] "logistic_regression_-_script_for_ppt.html"
## [137] "lyncentry.exe"
## [138] "Machine+Learning++Part+1 (1).ipynb"
## [139] "Machine+Learning++Part+1.ipynb"
## [140] "March invoice Indicus - Sheet1.pdf"
## [141] "matplotlib+cars.ipynb"
## [142] "matplotlib+line+graph.ipynb"
## [143] "mongodb-win32-x86_64-2008plus-ssl-3.4.2-signed.msi"
## [144] "mongodb-win32-x86_64-3.4.2-signed.msi"
## [145] "mortDefault"
## [146] "mortDefault.zip"
## [147] "mtcarslm.R"
## [148] "multiple+file+concat+in+pandas (1).ipynb"
## [149] "multiple+file+concat+in+pandas.ipynb"
## [150] "my+first+class+in+python.ipynb"
## [151] "nltk.ipynb"
## [152] "notebook-Copy1.html"
## [153] "Offer Letter - Ajay Ohri (1).pdf"
## [154] "Offer Letter - Ajay Ohri.pdf"
## [155] "Other Data Mining Methods (1).pdf"
## [156] "Other Data Mining Methods.pdf"
## [157] "output1 (1).xls"
## [158] "output1 (2).xls"
## [159] "output1.xls"
## [160] "pandas+11.ipynb"
## [161] "pandas+analysis+1.ipynb"
## [162] "pandas+data+manipulation.ipynb"
## [163] "passport image.pdf"
## [164] "Pawconinvoice2016.pdf"
## [165] "Pawconinvoice2017 (1).pdf"
## [166] "Pawconinvoice2017 (2).pdf"
## [167] "Pawconinvoice2017 (3).pdf"
## [168] "Pawconinvoice2017.pdf"
## [169] "Payslip Feb 2016 - Sheet1.pdf"
## [170] "Payslip Feb 2016.pdf"
## [171] "Payslip Format Decisionstats - Sheet1.pdf"
## [172] "Payslip Jan 2016 - Sheet1.pdf"
## [173] "Payslip Jan 2016.pdf"
## [174] "Payslip March 2016 - Sheet1.pdf"
## [175] "Payslip March 2016.pdf"
## [176] "pgd.csv"
## [177] "postgresql-9.6.1-1-windows-x64.exe"
## [178] "Program 1-results.rtf"
## [179] "protein.csv"
## [180] "Python.docx"
## [181] "python+with+postgres (1).ipynb"
## [182] "python+with+postgres.ipynb"
## [183] "R-3.3.2-win.exe"
## [184] "R-3.3.3-win.exe"
## [185] "RCertificationExam.pdf"
## [186] "reg+model.ipynb"
## [187] "Revision - Business Analytics (1).pdf"
## [188] "Revision - Business Analytics.pdf"
## [189] "RidingMowers.csv"
## [190] "rsconnect"
## [191] "RStudio-1.0.136.exe"
## [192] "Salary Slip, Feb 2016.pdf"
## [193] "Salary Slip, Jan 2016.pdf"
## [194] "Salary Slip, March 2016 (1).pdf"
## [195] "Salary Slip, March 2016 (2).pdf"
## [196] "Salary Slip, March 2016.pdf"
## [197] "sales-of-shampoo-over-a-three-ye.csv"
## [198] "sas-university-edition-107140.pdf"
## [199] "SAS part 2.pdf"
## [200] "SAS Part 3.pdf"
## [201] "Scan0095.pdf"
## [202] "Scanned Invoice for Collabera.pdf"
## [203] "Screenshot 2017-01-23 12.36.55.png"
## [204] "September invoice adaptive analytics - Sheet1.pdf"
## [205] "simple+matplot+graph.ipynb"
## [206] "Sollers January.pdf"
## [207] "sqlalchemy.ipynb"
## [208] "stackoverflow-dump-analysis.html"
## [209] "Sunstone.pdf"
## [210] "Tableau.pdf"
## [211] "TableauPublicDesktop-64bit-10-1-3.exe"
## [212] "TableauPublicDesktop-64bit-10-1-4.exe"
## [213] "telecom.csv"
## [214] "TelecomServiceProviderCaseStudy.pdf"
## [215] "test+web+scraping.ipynb"
## [216] "Text Mining (1).pdf"
## [217] "Text Mining.pdf"
## [218] "third.sas7bdat"
## [219] "Time Series Forecasting (1).pdf"
## [220] "Time Series Forecasting.pdf"
## [221] "ts.html"
## [222] "ts.R"
## [223] "Unconfirmed 373974.crdownload"
## [224] "Unconfirmed 376991.crdownload"
## [225] "Unconfirmed 950045.crdownload"
## [226] "Unconfirmed 952275.crdownload"
## [227] "uTorrent.exe"
## [228] "VirtualBox-5.1.8-111374-Win (1).exe"
## [229] "VirtualBox-5.1.8-111374-Win.exe"
## [230] "visualcppbuildtools_full.exe"
## [231] "Web+Scraping+Yelp+with+Beautiful+Soup.ipynb"
## [232] "Webinar for Business Analytics.pdf"
## [233] "WhatsApp Image 2017-02-18 at 08.42.55 (1).jpeg"
## [234] "WhatsApp Image 2017-02-18 at 08.42.55.jpeg"
## [235] "YourPayslip_April2017.pdf"
## [236] "YourPayslip_March2017.pdf"
dir(pattern='csv')
## [1] "AirPassengers.csv"
## [2] "BigDiamonds.csv"
## [3] "BigDiamonds.csv (1).zip"
## [4] "BigDiamonds.csv (2)"
## [5] "BigDiamonds.csv (2).zip"
## [6] "BigDiamonds.csv (3).zip"
## [7] "BigDiamonds.csv.zip"
## [8] "Boston (1).csv"
## [9] "Boston.csv"
## [10] "ccFraud.csv"
## [11] "class2.csv"
## [12] "data1.csv"
## [13] "datasets.csv"
## [14] "Diamond (1).csv"
## [15] "Diamond (2).csv"
## [16] "Diamond (3).csv"
## [17] "Diamond (4).csv"
## [18] "Diamond (5).csv"
## [19] "Diamond (6).csv"
## [20] "Diamond (7).csv"
## [21] "Diamond (8).csv"
## [22] "Diamond.csv"
## [23] "Hdma.csv"
## [24] "Hedonic.csv"
## [25] "pgd.csv"
## [26] "protein.csv"
## [27] "RidingMowers.csv"
## [28] "sales-of-shampoo-over-a-three-ye.csv"
## [29] "telecom.csv"
a1=read.csv("AirPassengers.csv")
head(a1)
## X time AirPassengers
## 1 1 1949.000 112
## 2 2 1949.083 118
## 3 3 1949.167 132
## 4 4 1949.250 129
## 5 5 1949.333 121
## 6 6 1949.417 135
str(a1)
## 'data.frame': 144 obs. of 3 variables:
## $ X : int 1 2 3 4 5 6 7 8 9 10 ...
## $ time : num 1949 1949 1949 1949 1949 ...
## $ AirPassengers: int 112 118 132 129 121 135 148 148 136 119 ...