Python Pandas Tutorial 4: Read Write Excel CSV File

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ต.ค. 2024

ความคิดเห็น • 524

  • @codebasics
    @codebasics  2 ปีที่แล้ว +5

    Check out our premium machine learning course with 2 Industry projects: codebasics.io/courses/machine-learning-for-data-science-beginners-to-advanced

    • @wasimbader5706
      @wasimbader5706 ปีที่แล้ว

      Ur vids are great but in pandas I cud not bring my csv excel file into pandas. Syntax error or kernel not connected or other big red lines

  • @anshuraj5734
    @anshuraj5734 ปีที่แล้ว +6

    This is by far the best series on Pandas which I've came across till date. Thanks sir for making things look this easy.

  • @khansaluqman8665
    @khansaluqman8665 3 ปีที่แล้ว +10

    I was happy when you got the error with skip_rows and you showed us how to search for methods and debug your code. Amazing videos. Thanks a ton for teaching us :D

  • @brij1728
    @brij1728 4 ปีที่แล้ว +2

    after visiting many platform and youtube videos, I am learning actual thing in a practical way.

  • @NMAAJIDKHANMIS
    @NMAAJIDKHANMIS 5 ปีที่แล้ว +5

    By far the best series of videos you would ever find. Thanks.

  • @sagarmehla2102
    @sagarmehla2102 2 ปีที่แล้ว +1

    Showing how you resolve errors is the most important for us like you did as skip_rows.

  • @aryosetowicaksono
    @aryosetowicaksono 4 ปีที่แล้ว +2

    This is the best pandas tutorial so far!

    • @codebasics
      @codebasics  4 ปีที่แล้ว

      I am glad it was helpful

  • @debashissahoo5031
    @debashissahoo5031 6 ปีที่แล้ว +6

    got clear idea about data_frame and read_csv() - thank you
    one thing: your voice and english all matches to M. S. Dhoni.

  • @ritikajaiswal3824
    @ritikajaiswal3824 2 ปีที่แล้ว +19

    can't believe that these videos was made in 2017. still so much helpful and easy to understand

    • @codebasics
      @codebasics  2 ปีที่แล้ว +9

      I am happy this was helpful to you.

  • @thatguyadarsh
    @thatguyadarsh 5 ปีที่แล้ว

    your video tutorials are packed with soo much stuff....its like small packet but big explosion!! ..thank you so much for sharing ur valuable knowledge and experiences with us !!

    • @codebasics
      @codebasics  5 ปีที่แล้ว +1

      "Small package but big explosion" love that analogy adarsh ❤️ Thanks 😊

  • @sep69
    @sep69 6 ปีที่แล้ว +8

    Thank you for this great tutorial. Just getting started with pandas and your video's are a fantastic help :)

  • @mohanlpuri1
    @mohanlpuri1 4 ปีที่แล้ว

    Very clear explanation with examples. Quick tutorial to learn Panda use in Python. Excellent job.

    • @codebasics
      @codebasics  4 ปีที่แล้ว +1

      Mohan I am happy to help buddy :)

  • @fanchihk
    @fanchihk 5 ปีที่แล้ว +1

    Thank you. I love you work. You make the process simple, clear, direct.

    • @codebasics
      @codebasics  5 ปีที่แล้ว +1

      Fanchihk, thanks for sharing a valuable feedback 👍

  • @Mushsayer
    @Mushsayer 4 ปีที่แล้ว +40

    First of all, this the best tutorial I have seen on python and secondly you mention something else where people might have question in that topic. You answered all my questions when you are teaching. YOU ARE THE BEST!

    • @mymoviemania1
      @mymoviemania1 5 หลายเดือนก่อน

      What are you doing currently?

  • @ankitaxalxo409
    @ankitaxalxo409 2 ปีที่แล้ว

    Thanks a lot. I was unable to import data in jupyter. Your video really helped me.

  • @abdulbasithos8805
    @abdulbasithos8805 4 ปีที่แล้ว

    Ultimate for spreadsheet automations users.
    Thanks for this tutorial and requesting to make some videos related to styling of cells.

    • @codebasics
      @codebasics  4 ปีที่แล้ว +1

      Abdul I am glad you found this to be useful 👍

  • @kannanv8831
    @kannanv8831 4 ปีที่แล้ว

    Every tutorial getting me excited. A best tutorial of pandas.

    • @codebasics
      @codebasics  4 ปีที่แล้ว

      Happy to hear that!

  • @RAGHURAM-jb6qc
    @RAGHURAM-jb6qc 4 ปีที่แล้ว +1

    Thanks for the videos, everything is so clear. Really love them

    • @codebasics
      @codebasics  4 ปีที่แล้ว +1

      Happy to hear that!

  • @codebasics
    @codebasics  4 ปีที่แล้ว +10

    Step by step roadmap to learn data science in 6 months: th-cam.com/video/H4YcqULY1-Q/w-d-xo.html

  • @mohitgupta1958
    @mohitgupta1958 6 ปีที่แล้ว

    Fantastic Videos. Covered all necessary functionalities with maximum ease. Thanks a lot :-)

  • @duna7381
    @duna7381 7 ปีที่แล้ว

    Great videos! There are many details I didn't know about pandas. Thx for the effort. Waiting for further videos :)

  • @loveSG999
    @loveSG999 4 ปีที่แล้ว +12

    Dear Sir, I truly appreciate your teaching style: always clear, straight to the point, and thorough enough to cover the logics behind each task! I also like how you break things down to simple terms using plain English so that IT challenged people like me can easily understand! I will stay tuned to your TH-cam channel while continuing to learn python! Best Regards👍

    • @codebasics
      @codebasics  4 ปีที่แล้ว +1

      Scottie thanks for the detailed feedback buddy. It was certainly useful 😊👍

  • @codebasics
    @codebasics  4 ปีที่แล้ว

    How to learn coding for beginners | Learn coding for free: th-cam.com/video/CptrlyD0LJ8/w-d-xo.html

  • @jitu1856
    @jitu1856 6 ปีที่แล้ว +1

    best tutorials on pandas :) thanks

  • @rightwingtrollslayer
    @rightwingtrollslayer 7 ปีที่แล้ว +23

    Love your videos on Python and Pandas. Keep up the good work

  • @swetabhattacharjee1203
    @swetabhattacharjee1203 4 ปีที่แล้ว

    Your tutorials are best....thank u...learnt a lot from ur videos ....have subscribed your channel.. waiting for tutorials on other python modules like sklearn nltk keras

    • @codebasics
      @codebasics  4 ปีที่แล้ว +1

      For sklearn I already have a full series. Check it out on my channel it's called machine learning tutorials

  • @priyadarsinipaital5755
    @priyadarsinipaital5755 5 ปีที่แล้ว +1

    Thank you for this great tutorial. it's Awesome......which I found very helpful.

    • @codebasics
      @codebasics  5 ปีที่แล้ว

      Priyadarsini, I am glad you liked it

  • @gaddamshanthsri125
    @gaddamshanthsri125 5 ปีที่แล้ว +1

    superb teaching sir

    • @codebasics
      @codebasics  4 ปีที่แล้ว

      Thanks a lot for your kind works Sri Shanth. Stay in touch for more videos and share our channel if you really find it worth.

  • @mershadmajeed2246
    @mershadmajeed2246 4 หลายเดือนก่อน +1

    This video contains content:
    1) How to change anything from the start (df.read(.....)) and also using functions in python.
    2) When saving an excel file, how to change the column and row according to ours.
    3) When saving to excel file we can save it in sheet.

  • @ninonazghaidze7687
    @ninonazghaidze7687 5 ปีที่แล้ว +1

    Great thanks for the excellent tutorial!

  • @akshay4081
    @akshay4081 5 ปีที่แล้ว +1

    Phenomenal Videos Sir!!!
    One doubt how to create new data sheet in the same excel file

  • @rohank2825
    @rohank2825 4 ปีที่แล้ว

    ‘Those who know, do. Those that understand, teach.’ -Aristotle
    thank you very much sir for your effort .

    • @codebasics
      @codebasics  4 ปีที่แล้ว +1

      Another great quote Rohan 👏👏👏

  • @sriharshavardhan299
    @sriharshavardhan299 5 ปีที่แล้ว

    ur my teacher sir ... thank you sooo much

    • @codebasics
      @codebasics  5 ปีที่แล้ว +1

      Glad to be your teacher sri 😊🙏

  • @akshaynitin5589
    @akshaynitin5589 2 หลายเดือนก่อน

    Excellent tutorial.

  • @matosleni
    @matosleni 2 ปีที่แล้ว

    Wonderful class! I've just found your channel.
    Thank you!

  • @deekshithanand3094
    @deekshithanand3094 3 ปีที่แล้ว

    Sir the series is a great one to learn. But it would be great if you could have hosted the required dataset elsewhere or in a different repe. I had to clone to entire repo which had other things. So now I am doing copy and pasting csv in raw format from github!

  • @prasadhrv
    @prasadhrv 2 ปีที่แล้ว

    sir truly appreciate your teaching style and clear explanation. please suggest if my code is correct for excel value replacement (similar to csv value replacement for 'nan', instead of using the functions.plz sugget
    df = pd.read_excel("stock_data.xlsx","Sheet1",
    na_values = {'people':['-1','not applicable'],'eps':['-1','na']})
    df

  • @jananibalaji2782
    @jananibalaji2782 ปีที่แล้ว +5

    I want to take a moment and Thank you for all your efforts. I am in the beginning stages of learning Python and it has been very confusing. Your detailed tutorials are super helpful and I am learning a lot, taking notes! Bless You!

    • @codebasics
      @codebasics  ปีที่แล้ว +1

      Best of luck!

    • @dopamine8840
      @dopamine8840 7 หลายเดือนก่อน +1

      Hi jananibalaji, how are you? I'm in the stage where u were mentioned. Have u got ur job in Python or Data Science? If so I want big tips of real-time environment from u which will help me lot in understanding python much better and knowing the real world of python. could u help me in this? I believe that u know well about the huge difference between studying things and real world of things. Thank u

  • @paratalsrinivas3193
    @paratalsrinivas3193 5 ปีที่แล้ว

    Nice Video and explained very nicely. it helped me to resolve one of my problem.

    • @codebasics
      @codebasics  3 ปีที่แล้ว

      I am happy this was helpful to you.

  • @kennethgomes4727
    @kennethgomes4727 ปีที่แล้ว +1

    Instead of puttin -1 in the na_values to remove from revenue column, is there a way to give an argument which says if less than 0 then NaN ?

  • @MostafaMASLOUHI
    @MostafaMASLOUHI 6 ปีที่แล้ว

    Very nice works. Thank you for your efforts.

  • @hariharamoorthythennetipan2190
    @hariharamoorthythennetipan2190 7 ปีที่แล้ว

    Very nice detail explanation.

  • @TechnicalRNP
    @TechnicalRNP 3 ปีที่แล้ว +1

    UnicodeDecodeError: 'utf-8' codec can't decode bytes in position 0-1: invalid continuation byte , how to fix this error please reply , im getting this error while reading the csv file via pandas , pandas.read_csv("file.xlsx")

    • @vedparkash4182
      @vedparkash4182 3 ปีที่แล้ว

      File type is of "xlsx"
      Change it to "*.csv"

    • @TechnicalRNP
      @TechnicalRNP 3 ปีที่แล้ว

      @@vedparkash4182 thanks working🔥

  • @sameerparnami4995
    @sameerparnami4995 5 ปีที่แล้ว

    if you are getting "UnicodeDecodeError"
    try reading with below:
    data = pd.read_csv('file_name.csv', encoding='utf-8')
    and the other different encoding types are:
    encoding = "cp1252"
    encoding = "ISO-8859-1"
    Hope this helps !!

  • @zulfikaraziz
    @zulfikaraziz 4 ปีที่แล้ว

    Great Explanation,Thanks sir !

  • @MichaelGerrard
    @MichaelGerrard 3 ปีที่แล้ว

    For the Excel reading/writing I had to pip install openpyxl. That threw me a little but otherwise the video was very helpful, thanks lots! :-)

  • @gunjanpandey6234
    @gunjanpandey6234 ปีที่แล้ว

    hello sir , thank you this videos are really helpful for us. i am using na_values but it is not working in my dataframe how to fix this

  • @matheussazevedo9588
    @matheussazevedo9588 5 ปีที่แล้ว

    Very useful tips, thanks!

  • @abhishekdubey9920
    @abhishekdubey9920 3 หลายเดือนก่อน +1

    Converters functions is changing sam walton on every n.a. value in PEOPLE it doesn't checks for TICKERS . I put -1 on 1st row having tickers as google also changed to sam walton(changes larry page)

  • @rajeevmenon1975
    @rajeevmenon1975 2 ปีที่แล้ว +1

    Dhaval, pls help. I have a CSV file which has to be read. Using read_csv. Sample of CSV
    32324, 12000, C
    1A328, 25000, C
    MG024, 11111, C
    5201, 25, C
    First column has both numeric and alpha numeric eg, 32324,5201 is numeric whereas MG024 is alphanumeric.
    While converting pd converts 32324 as '32324' and '5201'. I want it to be converted as 32324 and 5201 and 'MG024'.

  • @reghasubhashini2908
    @reghasubhashini2908 4 ปีที่แล้ว

    amazing work seriously

  • @nitishmittal6764
    @nitishmittal6764 4 ปีที่แล้ว

    Hello , Your lectures are very good . can you tell me how to convert a column containing numbers (numbers are str type) into int or float.Also the numbers are having commas in between eg- "1,283" , "5,432"

  • @sampathkumar7234
    @sampathkumar7234 2 ปีที่แล้ว

    I need to read the DB and import to CSV file and need to compare the Imported two files and the report should be like Sheet 1 should hold the mismatched values with highlighting red colour for the values mismatched and sheet 2 and sheet 3 should be the imported file used to compare

  • @madnimmushrraf7142
    @madnimmushrraf7142 2 ปีที่แล้ว

    Thank you for this video

  • @mixupthings
    @mixupthings 4 ปีที่แล้ว

    superb sir!!

  • @MahmoudBacha.r.s_personal
    @MahmoudBacha.r.s_personal ปีที่แล้ว

    Thank you so much sir , OSU !

  • @andrewdouglas9559
    @andrewdouglas9559 ปีที่แล้ว +2

    This is the best tutorial on Pandas I've seen so far. Thanks for putting this together.

  • @kevinzhang8974
    @kevinzhang8974 7 ปีที่แล้ว +18

    I can't stop myself to keep learning Pandas by watching this series ... this is the best ...

    • @loveSG999
      @loveSG999 4 ปีที่แล้ว

      Totally agree mate

    • @CyberPin2001
      @CyberPin2001 4 ปีที่แล้ว

      Agree -better than any others I have watched and I have watched a lot.

  • @biswajitpatowary5784
    @biswajitpatowary5784 7 ปีที่แล้ว

    Hi..all your pandas tutorial videos are very helpful. Can we get tutorial videos for numpy, matplotlib, ggplot.
    Thanks in Advance

  • @gurumurthynagabhushana8775
    @gurumurthynagabhushana8775 4 ปีที่แล้ว

    Thank you so much for the great tutorial. Can you please post some videos on how to convert CAN database file to CSV using Python? I am looking for that solutions using pandas. Thank you.

  • @dkishore599
    @dkishore599 4 ปีที่แล้ว +1

    in case in People column if there n.a values (WMT, RIL) then how to fill those peoples by condition ?

  • @pushpayerraguntla3250
    @pushpayerraguntla3250 3 ปีที่แล้ว

    Ok,Thank you! I will upgrade.

  • @eliashossain9849
    @eliashossain9849 4 ปีที่แล้ว +2

    Thank you, instructor, to make the videos. Love your voice.

    • @codebasics
      @codebasics  4 ปีที่แล้ว +1

      Glad, you liked it

  • @janakiyeluripati6368
    @janakiyeluripati6368 4 ปีที่แล้ว

    Hello Code Basics, I'm following your pandas tutorial. To follow this video, how can i download the csv/excel files that you are working in the video. I mean i could see it in your gitbub page, but how to download it. Do i have to have Github account for that? Very nice explanation. Im finding it useful

    • @codebasics
      @codebasics  4 ปีที่แล้ว

      Janako go to room directory (py) and there you will see a green button for cloning the repo or download the code and CSV files as zip file

    • @janakiyeluripati6368
      @janakiyeluripati6368 4 ปีที่แล้ว

      @@codebasics yes got it. Thanks. Now I'm good to go. Love your tutorials

  • @hrishikeshdeka7141
    @hrishikeshdeka7141 3 ปีที่แล้ว

    I am following the exact same steps as you followed except the extension xlsx instead of csv. Still the program is showing error. Does it has to do anything with the office product activation??

  • @muhammadtashfain2192
    @muhammadtashfain2192 3 ปีที่แล้ว

    After creating a two dataframe content into same excel file in different sheet we can't remove our inedex please sir can you help me how to remove our index of different sheet in same excel file

  • @poojabhandari631
    @poojabhandari631 ปีที่แล้ว +1

    how to change converted csv file's position of rows and columns

    • @easydatascience2508
      @easydatascience2508 ปีที่แล้ว

      You can watch mine too. The channel has both Python and R playlists, and you can find link to source files in video description.

  • @bhaskarsubbaiah6002
    @bhaskarsubbaiah6002 4 ปีที่แล้ว

    can you please correct the error made at 20:41 you wrote pd.to_excel but later on you corrected that. Thanks

  • @rahathussain9313
    @rahathussain9313 3 ปีที่แล้ว

    I cannot convert my revenue column from Minus One( -1) to NaN with this code, while eps and people works fine-
    import pandas as pd
    df = pd.read_excel("E:\\DataScience\\CodeBasics\\weather_data.xlsx",sheet_name="stock_data",na_values={
    'eps': ["not available", "n.a."],
    'revenue': ["not available", "n.a.",-1],
    'people': ["not available","n.a."]

    })
    df

  • @user-mi8ew2to8e
    @user-mi8ew2to8e 5 ปีที่แล้ว

    Your videos are really nice.
    I'm just lazy

    • @codebasics
      @codebasics  5 ปีที่แล้ว

      Don't think you are lazy himanshu. Just tell to your self I am proactive and I can do it. That mental assurance is very very powerful, trust me !

  • @nawazzaidi85
    @nawazzaidi85 4 ปีที่แล้ว

    Thanks for this video and i have one question suppose we have 50 records in an excel file and we want to read every 10th record of it and store in extra excel Sheet so how can we do this.

    • @keshavmor1691
      @keshavmor1691 4 ปีที่แล้ว +1

      df[::10]
      use above slicing

  • @hadeedahmed7693
    @hadeedahmed7693 2 ปีที่แล้ว

    how to downliad that csv file

  • @NabeelButt
    @NabeelButt 2 ปีที่แล้ว +1

    Definitely one of the best Pandas tutorial that I've found on internet. However, I got a bit confused when you called the converter function inside a dictionary and didn't use any arguments whereas the function had converters(cell) as argument. How did that work? Thanks!

  • @nomixzone8592
    @nomixzone8592 5 ปีที่แล้ว +1

    name 'file.csv' is not defined
    ..
    how can i solve that problem???

  • @abel_edes442
    @abel_edes442 4 ปีที่แล้ว

    see also great vid for organizing and parsing, indexing .csv: th-cam.com/video/E_iY_qTJ7Is/w-d-xo.html

  • @getosuguru-i6c
    @getosuguru-i6c ปีที่แล้ว +1

    This class is a gem ♥♥♥

  • @ibrahimkhalilrazu9653
    @ibrahimkhalilrazu9653 7 ปีที่แล้ว

    Thanks for the tutorial. However, i guess converter compares only a string, not the numbers. I've been trying to play with conditional statements and it hits errors. Following is my code which didn't work:
    TypeError: '>' not supported between instances of 'str' and 'int'
    Here is my code:
    def convert_price_cell(cell):
    if cell > 1023:
    return 'Too much price'
    return 'Affordable'
    def convert_revenue_cell(cell):
    if cell == "-1":
    return "Too low"
    return cell
    df = pd.read_excel("panda_excel.xlsx", "Sheet1", converters =
    {'people': convert_people_cell,
    'eps': convert_eps_cell,
    'tickers': convert_tickers_cell,
    'price': convert_price_cell,
    'revenue': convert_revenue_cell})

  • @hosseiniphysics8346
    @hosseiniphysics8346 8 หลายเดือนก่อน

    ❤❤❤❤nice

  • @shreeniketjoshi
    @shreeniketjoshi 4 ปีที่แล้ว +1

    Hello, thanks for the tutorial. I'm a beginner in python and currently working on Silicon thin film fabrication. I'm facing an issue with writing a python code for it. Can you please tell me how can I go about it?
    I have data points from my experiments (about 1000 cells in excel), I want to input these excel cells into python, assign them to variables (one at a time), and solve equations and output the solution to a new excel cell.
    Once this is completed, I want the code to accept the second input from excel and again repeat this process.
    I was thinking about a for loop counter. If you can direct me to the correct web resources, that would be great!
    Thanks a bunch!

    • @sudipanpaul805
      @sudipanpaul805 2 ปีที่แล้ว

      just do
      for i,j in zip(value list, variable list):
      i = j

  • @inspirational_talkings2099
    @inspirational_talkings2099 6 ปีที่แล้ว +1

    Sir, I am trying to read the excel file but I am not able to do it....My file name is 'student.xlsx'.....i wrote :
    df=pd.read_excel('student.xlsx')
    df
    But, it is showing error which is:
    FileNotFoundError: [ Errno 2] No such file or directory: ' student.xlsx'
    Sir, plz figure out my problem bcoz it is creating an obstacle for me to proceed with pandas ????

    • @BwithGadgets
      @BwithGadgets 5 ปีที่แล้ว

      For Excel files it shud b pd.ExcelFile("filename or location.xlsx)

    • @arjunk5959
      @arjunk5959 5 ปีที่แล้ว

      Is your file under root directory of Python ?

  • @yadikishameer9587
    @yadikishameer9587 3 ปีที่แล้ว +1

    Videos are just perfect. I just wanna know are you a data scientist or analyst.

    • @codebasics
      @codebasics  3 ปีที่แล้ว +1

      I am a data engineer. Now you will ask me what is the difference between the three :) Well I have a video on explaining the difference between these 3 roles.

    • @yadikishameer9587
      @yadikishameer9587 3 ปีที่แล้ว +1

      @@codebasics data engineer sounds like king of data oriented IT jobs. Keep it up.

  • @Plankton_Doctor
    @Plankton_Doctor 6 ปีที่แล้ว

    Thank u sir! subscribed

  • @HaseebHeaven
    @HaseebHeaven 4 ปีที่แล้ว

    Why are you running Localhost to run Python ? You can use VSCode.

  • @subee128
    @subee128 ปีที่แล้ว +1

    Thanks

  • @subikshamohan
    @subikshamohan 2 หลายเดือนก่อน

    i have a doubt in this video.plz explain me,why the statement is df=pd.read_csv("stock_data.csv"), we use only excel file.will you plz explain.

  • @walkwithus6536
    @walkwithus6536 ปีที่แล้ว

    if we have two table csv in one page, how to separate these into two separate table CVS file?

  • @PravinMaske1
    @PravinMaske1 ปีที่แล้ว

    AttributeError: module 'pandas' has no attribute 'to_excel'

  • @hometv5043
    @hometv5043 ปีที่แล้ว

    Hi Boss,
    Need your attention , may be i am doing wrong something here
    I created a Dataframe
    Name age weights Price location
    aman 10 77 100 Krishna Nagar
    meeti 20 888 222 n.a
    bani -2 22 33 tilak
    toni not available 60 123 nagar
    Lovely 7.5 -2 n.a Krishna
    import pandas as pd
    df=pd.read_excel("Day4_CB.xlsx",na_values={"age":["not available","n.a"],
    "weights":["not available","n.a",-2],
    "Price":["not available","n.a"],
    "location":["not available","n.a"]})
    print(df)
    I am trying to replace -2 with na - but changes are not happening but when you tried with -1 in your video it was all good.
    Can you help here - any suggestions.
    Regards,

  • @christopherjspiteri
    @christopherjspiteri 3 ปีที่แล้ว +1

    Maybe 6 or 7 mins in and you have helped me out already, thanks. Not sure if I have posted a comment before but your pace and diction are greatly appreciated, content is clear and to the point, again thank you. Stay healthy and safe.

  • @curious_bird
    @curious_bird 2 ปีที่แล้ว

    Sir, what is UnicodeDecodeError while reading excel files in jupyter notebook?

  • @azadahmed-r6b
    @azadahmed-r6b 4 หลายเดือนก่อน

    sir, i m following your AI engineer roadmap form for the last 3 months and the first time got struck at a point. After creating a new column, I could not understand the to_csv function and found no amendment in my csv file. Can you please help me through this.

  • @jatinfalwaria7087
    @jatinfalwaria7087 7 ปีที่แล้ว +11

    where is your csv file stored in pc???
    coz m getting an error of file not found.
    Much appreciated video content .Thanx :)

    • @jatinfalwaria7087
      @jatinfalwaria7087 7 ปีที่แล้ว

      codebasics thanx buddy😁

    • @alokpratap2094
      @alokpratap2094 6 ปีที่แล้ว

      codebasics sir how we can give the absolute path, sir please help me

    • @inclinedscorpio
      @inclinedscorpio 5 ปีที่แล้ว +2

      whereever the csv be located , just after opening your notebook go to upload and then from browse go to location your file is located and upload it !!

    • @herlinanapitupulu5593
      @herlinanapitupulu5593 4 ปีที่แล้ว +1

      @Nirav.Raval Mtech2018 Thanks so much..

    • @shan5612
      @shan5612 4 ปีที่แล้ว

      If you have got the Answer plz write it here.

  • @rezwanakabir8914
    @rezwanakabir8914 4 ปีที่แล้ว

    Hi I downloaded your csv files and kept in download folder. When i try to run this tutorial in jupyter, it could not find the file. I am a beginner in python. Your advice will greatly help me. I copied and pasted the whole thing. Please help. Thanks.
    import pandas as pd
    df = pd.read_csv("stock_data.csv")
    df
    ---------------------------------------------------------------------------
    FileNotFoundError Traceback (most recent call last)
    in
    1 import pandas as pd
    ----> 2 df = pd.read_csv("stock_data.csv")
    3 df
    ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in parser_f(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, dialect, error_bad_lines, warn_bad_lines, delim_whitespace, low_memory, memory_map, float_precision)
    683 )
    684
    --> 685 return _read(filepath_or_buffer, kwds)
    686
    687 parser_f.__name__ = name
    ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in _read(filepath_or_buffer, kwds)
    455
    456 # Create the parser.
    --> 457 parser = TextFileReader(fp_or_buf, **kwds)
    458
    459 if chunksize or iterator:
    ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in __init__(self, f, engine, **kwds)
    893 self.options["has_index_names"] = kwds["has_index_names"]
    894
    --> 895 self._make_engine(self.engine)
    896
    897 def close(self):
    ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in _make_engine(self, engine)
    1133 def _make_engine(self, engine="c"):
    1134 if engine == "c":
    -> 1135 self._engine = CParserWrapper(self.f, **self.options)
    1136 else:
    1137 if engine == "python":
    ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in __init__(self, src, **kwds)
    1915 kwds["usecols"] = self.usecols
    1916
    -> 1917 self._reader = parsers.TextReader(src, **kwds)
    1918 self.unnamed_cols = self._reader.unnamed_cols
    1919
    pandas\_libs\parsers.pyx in pandas._libs.parsers.TextReader.__cinit__()
    pandas\_libs\parsers.pyx in pandas._libs.parsers.TextReader._setup_parser_source()
    FileNotFoundError: [Errno 2] File b'stock_data.csv' does not exist: b'stock_data.csv'

  • @thangellaroopnaveen2601
    @thangellaroopnaveen2601 4 ปีที่แล้ว

    sir, not working for me, what should i need to install, please help...
    i cannot read any file or do anything, error occurs..
    using jupyter notebook...

  • @MrGaurav525
    @MrGaurav525 2 ปีที่แล้ว

    10:00
    na_values :scalar, str, list-like, or dict, default None
    na_values does not take int object, as shown in pandas documentation.
    How come -1 changed to NaN.
    My 0 is not changing in this manner?

  • @itguy5192
    @itguy5192 4 ปีที่แล้ว

    I need to know whether this can be automated or not: I get one raw data details on excel sheet on mail with attachment, this attached excel sheet gets automatically downloaded to certain location and then macro runs on that excel file as per schedule and then that excel sheet is send to several email addresses as per schedule without human intervention? What is required to do this automation?

  • @sameerjadhav3044
    @sameerjadhav3044 3 ปีที่แล้ว

    while performing this tutorial some error encountered as FileNotFoundError something like that how to solve this type of error ??? suggest me solution for that

  • @vinodreddy763
    @vinodreddy763 2 ปีที่แล้ว

    Error no such file or dictionary: :'file name'. Y I'm giving correctly but every time it's error?

  • @pranab9429
    @pranab9429 3 ปีที่แล้ว

    My excel file is in the same directory as of jupyter notebook but I'm getting filenotfound error

  • @ArunKumar-mc1xi
    @ArunKumar-mc1xi 3 ปีที่แล้ว

    How to almost 65csv files into single excel file , those 65 CSV in each sheet of the excel file in databricks