How to Import Excel and CSV files into Python using Jupyter Notebooks || Python for Scientists

Sdílet
Vložit
  • čas přidán 11. 09. 2024

Komentáře • 41

  • @Julian-hw6zf
    @Julian-hw6zf Před 2 měsíci +1

    thank you very much!! I've been dealing with this issue for one or two days and finally someone explained it clearly :).

  • @praiseemma-iwuozo6938
    @praiseemma-iwuozo6938 Před rokem +2

    Thanks so much. This was greatly helpful. Was already getting frustrated but your video answered all my questions.

  • @user-bk8sp6ef2m
    @user-bk8sp6ef2m Před rokem

    Thank you! I get so frustrated when I don't know what I don't know and you did a beautiful job explaining everything here!

  • @xytay
    @xytay Před 2 měsíci

    Thank you, by far the clearest and best structured simple vid, I was able to open my csv file with your help!

  • @aavere3284
    @aavere3284 Před 6 měsíci

    You are a godsend
    I have an assignment due tommorow and I didn't even know where to start

  • @vibespriority201
    @vibespriority201 Před rokem +1

    Very nice and clear explanation! Thank you!

  • @StructuredData-cp2yi
    @StructuredData-cp2yi Před 3 měsíci

    came here specifically to say a big thank you for solving my errors. I see others agree with me as well😃😃

  • @FatosZogjani
    @FatosZogjani Před 2 dny

    great video,very helpful!👍

  • @kateb5659
    @kateb5659 Před rokem

    Thank you! I had be struggling with this on a homework assignment and this made it so simple to find my error!

  • @danielbarnes478
    @danielbarnes478 Před 2 lety

    Thank you for the help, excellent job walking through all the steps! I was getting frustrated with other videos I was finding not explaining things well.

  • @jashanbhamra103
    @jashanbhamra103 Před 2 měsíci

    Im getting the same error thousand times handle open( self.handles=get handle can you tell me whats wrong

  • @johnnyturner8044
    @johnnyturner8044 Před rokem

    You provided an easily understandable example. Thank you!

  • @haroldasraz
    @haroldasraz Před 9 měsíci

    Cheers for a great video.

  • @pemayangzom4358
    @pemayangzom4358 Před rokem

    Thank you so much. It helped me a lot

  • @eng.miroslavmanahilov1944
    @eng.miroslavmanahilov1944 Před 3 měsíci

    Thank you.

  • @cocostar8914
    @cocostar8914 Před rokem

    Thank you so much, this was really helpful

  • @Carolinelias
    @Carolinelias Před rokem

    Thank you. Can you please help me import 1 column from 4 multiple csv files? let's say the column ['Adjusted Close'] available in 4 csv files: Procter and Gamble, Ford, General Electric and Microsoft. Thank you!

    • @SciGradCoach
      @SciGradCoach  Před rokem

      You just need to import all 4 columns and then only select the one column from each file.

  • @rohitagnihotri2074
    @rohitagnihotri2074 Před 5 měsíci

    thannnkkkk yoouuuu so much

  • @qusay6948
    @qusay6948 Před 2 lety

    CAN WE USE THE PYTHON TO ANALYSE THE SCOPUS DATASET?

    • @SciGradCoach
      @SciGradCoach  Před 2 lety +1

      You can use Python to analyze any data set!

  • @qusay6948
    @qusay6948 Před 2 lety

    But why you did not upload the command file?

  • @meandtheuniverse1449
    @meandtheuniverse1449 Před rokem

    thank you for this

  • @Yasser.Moussa
    @Yasser.Moussa Před 2 lety

    tried with xlsx and csv

  • @EG101ify
    @EG101ify Před 9 měsíci

    i love you

  • @LeonidasParigoris
    @LeonidasParigoris Před rokem

    Jesus... it wasn't working for me until I found out it was an xlsx file and had to convert it to csv

  • @moouodsh6504
    @moouodsh6504 Před 10 měsíci

    🤍

  • @Yasser.Moussa
    @Yasser.Moussa Před 2 lety

    hi
    it's given me this error
    import pandas as pd
    pd.read_xlsx("data1.xlsx")
    AttributeError Traceback (most recent call last)
    Input In [5], in ()
    ----> 1 pd.read_xlsx("data1.xlsx")
    File ~\anaconda3\lib\site-packages\pandas\__init__.py:261, in __getattr__(name)
    257 from pandas.core.arrays.sparse import SparseArray as _SparseArray
    259 return _SparseArray
    --> 261 raise AttributeError(f"module 'pandas' has no attribute '{name}'")
    AttributeError: module 'pandas' has no attribute 'read_xlsx'

    • @SciGradCoach
      @SciGradCoach  Před 2 lety +1

      It should be pd.read_excel not pd.read_xlsx. I hope that helps!

  • @qusay6948
    @qusay6948 Před 2 lety

    Thank you.