Pengenalan phyton

[Marsi Marsi]

Muncul error seperti ini :

#import data

TrSet = pd.read_csv(“TrSet.csv”)
FileNotFoundError: [Errno 2] No such file or directory: ‘TrSet.csv’

Saat setworking directory di anaconda prompt selalu seperti ini :
(base) C:\Users\alway> DS Dataset Mahir
‘DS’ is not recognized as an internal or external command,
operable program or batch file.

Saya berulang kali lihat video set working directory tetapi tidak berhasil. Saya benar-benar kesulitan bagaimana mengatasinya coach?

[Coach William]

Dear Marsi,

Penggunaan command prompt untuk menentukan lokasi bukan untuk membuka file.. jika melihat error kamu, seharusnya python kamu skrg ada di dalam folder alway. Tempatkan file ds dasar dataset di alway tsb, lalu extract terlebih dahulu.

Regards
William

[Marsi Marsi]

Coach ini bagaimana solusinya ada 2 kendala mohon solusinya?

1)
Path = r”C:\Users\Mars\latihanExportExcel.xlsx”
writer = pd.ExcelWriter(Path,engine = ‘xlsxwriter’)
varexport.to_excel(writer, sheet_name = ‘nama halaman’)
writer.save()
writer.close()

—————————————————————————
ModuleNotFoundError Traceback (most recent call last)
Cell In[77], line 2
1 Path = r”C:\Users\Mars\latihanExportExcel.xlsx”
—-> 2 writer = pd.ExcelWriter(Path,engine = ‘xlsxwriter’)
3 varexport.to_excel(writer, sheet_name = ‘nama halaman’)
4 writer.save()

File ~\anaconda3\Lib\site-packages\pandas\io\excel\_xlsxwriter.py:198, in XlsxWriter.__init__(self, path, engine, date_format, datetime_format, mode, storage_options, if_sheet_exists, engine_kwargs, **kwargs)
185 def __init__(
186 self,
187 path: FilePath | WriteExcelBuffer | ExcelWriter,
(…)
196 ) -> None:
197 # Use the xlsxwriter module as the Excel writer.
–> 198 from xlsxwriter import Workbook
200 engine_kwargs = combine_kwargs(engine_kwargs, kwargs)
202 if mode == “a”:

ModuleNotFoundError: No module named ‘xlsxwriter’

2)
varexport.csv(‘fileexportcsv.csv’)
—————————————————————————
AttributeError Traceback (most recent call last)
Cell In[69], line 1
—-> 1 varexport.csv(‘fileexportcsv.csv’)

File ~\anaconda3\Lib\site-packages\pandas\core\generic.py:5902, in NDFrame.__getattr__(self, name)
5895 if (
5896 name not in self._internal_names_set
5897 and name not in self._metadata
5898 and name not in self._accessors
5899 and self._info_axis._can_hold_identifiers_and_holds_name(name)
5900 ):
5901 return self[name]
-> 5902 return object.__getattribute__(self, name)

AttributeError: ‘DataFrame’ object has no attribute ‘csv’

[Coach William]

Hi Marsi,
Untuk error2 python ada banyak pembahasannya di stack overflow yaa

https://stackoverflow.com/questions/27385097/importerror-no-module-named-xlsxwriter

https://stackoverflow.com/questions/34087903/dataframe-object-has-no-attribute-read-csv

[Author]

Posts