[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’

[Author]

Posts