Psycopg2 Errors on SQL statement when trying to copy data from CSV file into PostgreSQL database
sqlcopy = "COPY irwin (fire_id,name,type,acres,date_time,state,county,admin_unit,land_cat,commander,perc_cntnd,cont_date,gacc,lat,long,geom,updated,imo)  FROM STDIN WITH FORMAT CSV, HEADER")


copy doesn't do values..., the columns in the input must be correctly formatted for the columns you list, also format CSV is usually a better choice than delimiter ',' 

what copy expert actually does is open a channel to the postgresql copy command. and then squirt the file contents through that channel.
so you need to format the query for what postgres wants.

https://www.postgresql.org/docs/10/sql-copy.html